Тёмный
Hari's BI
Hari's BI
Hari's BI
Подписаться
This channel provides more information about Power BI and Power Platform related Videos. This will help you understand the concepts as it covers the detailed information for each topic.

Power BI - DAX, Data Modeling, Automation, Paginated Reports, Power BI Desktop and etc.
My Microsoft  MVP Award
0:20
3 года назад
Комментарии
@Remi-ni5uf
@Remi-ni5uf 32 минуты назад
Hi Hari, great video! Im not able to get past 11:22 in the video, i get the following message when running this XMLA query, any ideas what could be wrong? I've followed step by step before that. Im using SQL server management studio 20.1 I have tried three different workspaces and different Usage Metrics Reports... , on where i am admin/creator, same error message on all three. Result: Executing the query ... Lists of BinaryXml value tokens not supported. Run complete Query { "export": { "layout": "delta", "type": "full", "objects": [ { "database": "Name of our database" } ] } }
@Remi-ni5uf
@Remi-ni5uf 3 минуты назад
Answering myself here.. i dont get the same log as you in sql server management studio, but after syncing One Lake another time the Parquet files etc. is available.. Maybe it works.. must continue with the video :)
@sabinkrshrestha9536
@sabinkrshrestha9536 День назад
I am receiving delayed alert emails after setup. Is there a way to change the refresh interval and minimize the delay time for the fabric capacity usage ?
@HariBI
@HariBI 19 часов назад
The alert frequency or streaming data from semantic model to reflex is every 1 hour which Can nor be adjusted
@DanielSilva-sr1dm
@DanielSilva-sr1dm День назад
Pretty good presentation and video!! Would be possible to have this presentation? Where to find it?
@DanielSilva-sr1dm
@DanielSilva-sr1dm День назад
Pretty good presentation and video!! Would be possible to have this presentation? Where to find it?
@pavanprajapati3877
@pavanprajapati3877 День назад
Hello, i create one dashboard, i achive i publish report after how refresh every time using rest api, i create one rest api but access token is expired, when i call api my project i add this report but acess token expire when show error how fix
@ganeshp3125
@ganeshp3125 5 дней назад
Could you share video how to power automate along with these filters
@junminnie
@junminnie 6 дней назад
Hi Hari, I can't seem to be getting the historical data. I've ingested first time 30 days. As a result, my warehouse shows dates 19 Sep to 20 Oct. Then, I changed the parameter to 1 day, and refresh my data flow daily. However, I notice that the dates are still 30 days. For example, today I'm getting 22 Sep to 23 Oct data... How do I save the history?
@HariBI
@HariBI 6 дней назад
If you choose Append then you should see
@junminnie
@junminnie 2 дня назад
Hi @@HariBI , I'm facing error when I changed to Append for the Dates table under Others folder. In my report, it says duplicate value is not allowed for many to one relationship. Error: column Date in Table Dates contains a duplicate value 45561 and this is not allowed for columns on the one side of a many to one relationship or for columns that are used as the primary key of a table. Dates is Append Refresh Stats is Replace Tables under Facts are Append Tables under Dimensions are Replace YesterdayDate is not ingested to Data Warehouse
@junminnie
@junminnie 21 час назад
@@HariBI btw append doesn't work as well :/ it's not 28 Sep to 29 Oct
@VikasSingh-wu1er
@VikasSingh-wu1er 8 дней назад
Great Brother
@junminnie
@junminnie 8 дней назад
How do you create the sql endpoint? I only have the default semantic model under data warehouse
@HariBI
@HariBI 8 дней назад
For Data warehouse, their is no dedicated sql endpoint you can check sql server name of the data warehouse
@junminnie
@junminnie 8 дней назад
Hi ​@@HariBI thanks for responding. One more question please: so does that mean I have to grant permission to other people who want to use SQL studio to query the data warehouse?
@HariBI
@HariBI 8 дней назад
@@junminnie yes I believe view access should work
@junminnie
@junminnie 8 дней назад
@@HariBI thank you very much!
@DanielLeBlanc-c5m
@DanielLeBlanc-c5m 12 дней назад
This is an amazing and helpful video. Thank you 100 times! But I noticed at 21:30, Report2 was deleted when you deleterd the data set. What's going on there?
@ManojKumar-m5y4o
@ManojKumar-m5y4o 13 дней назад
Hi Hari, any process for collating multiple workspaces data into one dataflow?
@MrV2707
@MrV2707 16 дней назад
Hi Hari, Any plans for multiple workspaces video?
@dubious88
@dubious88 16 дней назад
This is a simple and elegant solution to a very annoying problem. Thanks for sharing!
@pradeep5095
@pradeep5095 18 дней назад
Hi Hari, Thanks for the tip. Besides this I also have to do conditional formatting on the values which isn't possible now because of this parameter based output. Do you have any idea on achieving both?
@wonuggets905
@wonuggets905 19 дней назад
does this work in sso authenticator?
@jennifermaclachlan4790
@jennifermaclachlan4790 20 дней назад
Perfect thanks!
@MarcosBlanco-c1o
@MarcosBlanco-c1o 20 дней назад
How can I connect Power BI Desktop locally to a HANA database located on a remote server? I have tried to do this, but Power BI does not recognize that server when I attempt to connect.
@nishthatank5954
@nishthatank5954 20 дней назад
How to tackle if we get reputation in in parameter because generally we have multiple values in a parameter
@HariBI
@HariBI 20 дней назад
If you use Select statements then try use distinct to get only unique values
@alialjawhi560
@alialjawhi560 Месяц назад
You are Good Thank you
@souravpaul101
@souravpaul101 Месяц назад
Why I don't have the analitics pane in my power bi?
@emilymalkin270
@emilymalkin270 Месяц назад
I use pathcontains throughout, why do we need to use treatas at all…
@HariBI
@HariBI Месяц назад
This video is to show how to use DAX functions in Report builder. Demoed TREATAS function but it can be anything
@THIMMAREDDY-n3z
@THIMMAREDDY-n3z Месяц назад
Even though having admin role , I am unable to see Domain section in Admin Portal , can you help me out
@HariBI
@HariBI Месяц назад
If you have Power BI Tenant level admin then you should see Domains under Admin portal ( 6th secrion )
@OneNI83
@OneNI83 Месяц назад
Nice video and clear explanation. Just wanted to clarify ,when we create a warehouse and it's interface and sql analytics endpoints in Lakehouse interface both similar. That means if we create a lakehouse or warehouse using a same set of source tables the experience in both warehouse and lakehouse sql analytics endpoints are same?
@HariBI
@HariBI Месяц назад
No in general interface is similar only. It is not because of same tables
@OneNI83
@OneNI83 Месяц назад
@@HariBI What are the differences. I couldn't see any difference.
@AjinkyaKale_variable_X
@AjinkyaKale_variable_X Месяц назад
You can not add/modify any particular visual to an existing report page using copilot, can we?
@HariBI
@HariBI Месяц назад
Modifying visual on a page is not working using copilot now and it may come future
@MrV2707
@MrV2707 Месяц назад
Hey Hari, This is great, thanks. Can you please let me know how to handle it for multiple workspaces?
@koteswararao3668
@koteswararao3668 Месяц назад
Could you please tell how you created power query template for report model and also for date table does not have hierarchy while i tried to add hierarchy not adding.
@whaitmanMusic
@whaitmanMusic 2 месяца назад
Underestimated solution, simultaneously, so simple
@pavankumar-sg8wt
@pavankumar-sg8wt 2 месяца назад
very informative for me thanks, how did you get the measures and dimensions in SAP, Pls reply?
@HariBI
@HariBI 2 месяца назад
Those are all coming from HANA model itself
@ajinkyacgaikwad
@ajinkyacgaikwad 2 месяца назад
how to load audit logs to SQl without using power bi service?
@HariBI
@HariBI 2 месяца назад
You need to call activity events apis and store the results in SQL
@ajinkyacgaikwad
@ajinkyacgaikwad 2 месяца назад
@@HariBI could please make a video on that to fetch usage log from office 365 to SQL? 🥺 Please
@koteswararao3668
@koteswararao3668 2 месяца назад
@HariBi Could you please explain how we can load this historical data to sql server as incremental load. you have showed to create data model but not showed how to load data to sql server.
@juystafanreview2532
@juystafanreview2532 2 месяца назад
Is there a way to link to a dashboard but have it display information with a pre configured slicer?
@HariBI
@HariBI 2 месяца назад
Can you please elaborate your scenario?
@juystafanreview2532
@juystafanreview2532 2 месяца назад
@@HariBI Basically configure a filter to a URL. But after doing some research, this is not possible in PowerBI. Bookmarks are your best bet.
@rajpriya96.m
@rajpriya96.m 2 месяца назад
Check integrity in udt not showing results Although its running successfully
@ianmichelle5511
@ianmichelle5511 2 месяца назад
Your video is a tad lengthy, but it's comprehensive! and covers all the aspects! loved it!
@hariramkm1677
@hariramkm1677 2 месяца назад
Please post a updated video on this.
@iangeercke7169
@iangeercke7169 2 месяца назад
Hi Hari, I get the same error, even when trying to set the alert on the table version. Error is : An internal error occurred while creating your trigger. If this error persists, please contact support, quoting the following information: "Power BI metric query failed"
@iangeercke7169
@iangeercke7169 2 месяца назад
Just to add I can set alerts for the Ribbon visual
@hasanakhtar2120
@hasanakhtar2120 2 месяца назад
Your videos are so informative. Please upload videos consistently 😊. This video came after a gap of 3 months
@HariBI
@HariBI 2 месяца назад
Yes sure. Thank you for your feedback.
@bindiyathota3019
@bindiyathota3019 2 месяца назад
@HariBI , Thank you for the video! Could you also please explain what each of those ContentProviderTypes really mean, please?
@Seth_majestus
@Seth_majestus 2 месяца назад
I cant connect PBI dataset on service. What should I do now?
@nileshdighe2048
@nileshdighe2048 3 месяца назад
hello I'm using sql express 2019 and ssrs 2019 but im facing ssrs issue the product version of ssrs not shows hense ssrs not works why this happends please help
@jenndokken7904
@jenndokken7904 3 месяца назад
How do you get the Parameter to default to select "All" in the case where there is more than one value and to select the available value if there is only one?
@HariBI
@HariBI 3 месяца назад
You may need to handle in query level
@TheAvihoelbaz
@TheAvihoelbaz 3 месяца назад
Hey Hari, This is was great, thanks , do you think it's can work also for getting data from multiple workspaces? If I will connect them to onelake, and then will do this process two times (but won't replace the dimensions ) it can work, no ?
@anjuz1255
@anjuz1255 3 месяца назад
Hi, I'm using MS fabric trial version and now installed fabric metric capacity app. Given the trail version capacity Id while installing the app. The app installed but the report is not showing any data. Any idea why this happens?? Please reply
@HariBI
@HariBI 3 месяца назад
You need configure your app with your capacity id. If you have done then you should see the details on the metrics app
@bichannel3419
@bichannel3419 3 месяца назад
Hello, I have a question regarding paginated reports in Power BI. I have an embedded paginated report that calls another drill-through paginated report. When I click the back button from the drill-through report, the main paginated report resets all filter selections to their default values. Is there a way to retain the selected filter values in the main paginated report when navigating back from the drill-through report? Any help would be appreciated!
@kalpanatatode5435
@kalpanatatode5435 3 месяца назад
Hi can you please make video on how to connect power bi with S4 Hana without connectors
@SamirMonser-m9c
@SamirMonser-m9c 3 месяца назад
I'm a senior Data engineer from Belgium and this is one of the best videos i've ever seen about Fabric , a 38 minutes or rich high quality content . Congrats Hari! I have faced only small issue in saving the xmla in tabular editor , I'll look for alternatives
@HariBI
@HariBI 3 месяца назад
Thank you
@lakshmishivashankar7967
@lakshmishivashankar7967 3 месяца назад
Can I get this sample report
@powerbilearner
@powerbilearner 3 месяца назад
I have this same requiremnt. But parameter going to be numbers column (sales amt). When I click on sales value it should navigate to another report with required filter.
@MadhuSharma-dm7mj
@MadhuSharma-dm7mj 3 месяца назад
I am getting 400 when i update the database string in patch method
@saifulislam-xq9wh
@saifulislam-xq9wh 3 месяца назад
The video was really helpful. But there no data source