Solved: Selective data refresh

Anonymous · ‎01-28-2022

Is there a way to schedule full data refresh once a day (refresh of all tables) and partial data refresh (only one or a few tables) a number of times during the day?

StefanoGrimaldi · ‎01-28-2022

not on a regular bases, you would need to use either XMLA endpoints controls (primium capacity ) or using power shell https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!

View solution in original post

bcdobbs · ‎01-30-2022

You might find this useful:

https://insightsquest.com/2021/02/21/xmla-based-pbi-dataset-refresh-automation/amp/

Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

AnkitKukreja · ‎01-29-2022

Hi! @Anonymous

I agree with @StefanoGrimaldi you would have to use XMLA endpoints.

If my response has successfully addressed your question or concern, I kindly request that you mark this post as resolved. Additionally, if you found my assistance helpful, a thumbs-up would be greatly appreciated.
Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

StefanoGrimaldi · ‎01-28-2022

not on a regular bases, you would need to use either XMLA endpoints controls (primium capacity ) or using power shell https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!

Selective data refresh

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024