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.

For Power BI trainings or support dm or reach out to me on LinkedIn.
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