User Profile
PBI_RH
Regular Visitor
Joined 4 years ago
User Widgets
Contributions
Report Performance with Data Volume
We have one power bi report published to Power Bi Service. user large dataset storage format. the dataset with 1 year data is about 3 GB, the dataset with 3 years data is about 6.5 GB. There is one Matrix visualization in the report, I tested the DAX query in DAX studio. the Query performance is almost the same for 1 year and 3 years data. seems the data volumne didn't impact the performance which is good, but I want to know why. Can anybody let me know why this happen? thank you for your help in advance.Solved506Views0likes1CommentDataset Incremental Refresh - Append only or update/insert
Hi Everyone, Our ETL load data daily. I setup PBI dataset incremental refresh based on colume "ETL load time". Basically dataset append today's data only. I just found out that at the end of each month, the KPI columns will be updated for everyday in the whole month. Sep 1st load 001, 2022-09-01, 100 Sep2 incremental load, adding one row 001, 2022-09-01, 100 002, 2022-09-02, 120 ... ... Sep 30 incremental load, adding one row for sep30, also need to update KPI values for all the rows. 001, 2022-09-01, 105 002, 2022-09-02, 128 .... 030, 2022-09-30, 230. ========================= QQ: could you please let me know if it can be done by incremental load or I have to use full refresh?Solved795Views0likes2CommentsRe: How to calculate QTD and YTD based on MTD
Hi Tom, Unfortunately, my team has no control on the data side, I need to find a solution based on current data feed. So I won't be able to get the daily value. Let me try your solution to Reverse engineering the data column. really appreciate your help.1.3KViews0likes2CommentsHow to calculate QTD and YTD based on MTD
Hello, I have a table with MTD value calculated everyday by ETL team. as a report developer, how to calcuate QTD and YTD by using the MTD value? There is no daily value in the fact table. Date MTD QTD YTD 2022-01-01 5 2022-01-02 8 ..... 2022-01-30 100 2022-01-31 110 2022-02-01 2 2022-02-02 5 .... 2022-02-27 70 2022-02-28 76 ..... 2022-03-01 7 2022-03-02 11 ....1.3KViews0likes5Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.