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 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
I believe there is a difference. When I refresh the Access Databases from the PowerBI Desktop (i.e., I click the refresh button)...I never have had a failure driven by the Access Databases. When I publish the pbi file on my companies 'Workspace', and the my company's BI sets up the AutoRefreshes, the AutoRefresh routinely fails because of a 'Credentials/Gateway' issue driven by the Access Databases...stuff way above my head. I want to skip the Access Databases in the Auto-Refreshes to avoid the 'Gateway' issues.
But the credentials still apply on the manual refresh, unless you mean you refresh in the desktop and upload a new file every time you do that