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.
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" } ] } }
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 :)
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 ?
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
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?
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
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?
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?
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?
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.
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?
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.
@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.
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"
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
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?
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 ?
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
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!
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
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.
