Forum Discussion
Auto-Refresh select data tables / sources
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 🙂
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 feature
OMG. 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 🙂IT WORKED!!!! THANK YOU.
Quick question, may be hard to clearly ask. Basically, I am auto refreshing all Sql Server data sources and manually refreshing all Access Database data sources. The Access Database data sources have been causing Gateway / Credentials issues that have been causing the Auto-Refresh to crash. Given that I am no longer AutoRefreshing the Access Database data sources, this should avoid any of the Access Database-driven Gateway/Credential issues, correct?
