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?
hkillen well, if the Acess data sources caused the failures, then yes, now the scheduled won't have that reason. The manual refresh of access can still fail (there is no difference) but now you do it less, so it will happen less.
BTW, won't take you on your word for the kids 😆 but please be kind and give a Kudos to my report :))
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543