Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @PBI_RH
If you are using Power BI Pro you would have to do an entire dataset refresh.
If you are using Power BI Premium or Premium Per User you could then use the XMLA end point to then refresh the partitions needed.
Here is an example from my blog post where you can use Power Automate to complete this: Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL) - ...
Hi @PBI_RH
If you are using Power BI Pro you would have to do an entire dataset refresh.
If you are using Power BI Premium or Premium Per User you could then use the XMLA end point to then refresh the partitions needed.
Here is an example from my blog post where you can use Power Automate to complete this: Using the Power BI Async REST API to refresh a partition with Power Automate (Using an HTTPS URL) - ...
thanks a lot for the solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.