Forum Discussion
Auto-Refresh select data tables / sources
- 4 years ago
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 🙂
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
- hkillen4 years agoHelper I
I'm not an expert on this matter and my company's BI team cannot identify a solution. I can only report what I am experiencing. Just wanted validation when the AutoRefresh is conducted, the Access Database has zero impact. I will test it and get back to you.
- SpartaBI4 years agoCommunity Champion
Roger that