Forum Discussion
Auto-Refresh select data tables / sources
Is it possible to program PowerBI to only AutoRefresh select data tables? For example, if I have 10 data tables and I have PowerBI scheduled to auto-refresh at 0800. At the time Power BI Auto-Refreshes, I only want PowerBI to refresh 4 select tables. The other 6 tables, I will manually refresh when necessary.
hkillen haha I'm right don't worry 🙂
Will apprecite your kudos on my messages for start 😀.
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂
9 Replies
hkillen you can disable the refresh of the 6 tables in Power Query (right click on the relevant tables and you will see that toggle).
The scheduled refresh will only refresh the 4 you want.
For the other 6 you can do it manually through tools like Tabular Editor or SSMS but you need that dataset to resides in a Premium or PPU workspace as the xmla connection that is used for this mechanisem is a premium only featureOMG. I think you're right. Let me test it. If you are right, I will bear you your children. Will tell you how it works out. THANK YOU!
hkillen haha I'm right don't worry 🙂
Will apprecite your kudos on my messages for start 😀.
Please don't forget to accept the previous message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂
