Forum Discussion
I am unable to schedule a data refresh. I have successfully configured the Personal Gateway.
Microsoft EmployeeHey Jeremy,
Sorry about the issue! The error message means the credentials for the data source need to be updated.In your screenshot, I see ! symbols next to the File data source. Will you please click on those and update the credentials. Since it is a file data source, you'll be using Windows credentials. When you choose Windows credentials, you need to simply hit Sign In and it'll be accepted. If you are wondering, why do I not need to provide my windows credentials - this is because the Personal Gateway is running under your Windows credentials (when you set it up) and hence does not need your windows username/password to be entered in the Power BI service.
Hope this helps. Please update your credentials and you should be able to schedule refresh on the data source.
Thanks,
Mini
Advocate III uninstalled the Personal Gateway just now and reinstalled it.
I have a clearer picture of the issue now. When I originally created my queries, they were pointing at a file that was on a mapped network drive. The query used the mapped drive letter instead of the network address. I noticed this yesterday, and changed my queries to use the full network path instead of the mapped drive letter.
I originally created this in PowerBI Desktop, and I have deleted everything from PowerBI.com and cleared my data cache, and I went to PowerBI.com and used Get Data to re-pull the report into PowerBI.com (instead of using publish in PowerBI Desktop per some advice on another thread.)
Here's the strange/interesting part: when I look at the schedule now refresh options on PowerBI.com, I have 7 data connections, but only 4 queries. So PowerBI is trying to connect to those 3 original connections that were looking at a network mapped drive instead of the full network address. Those connections are kicking out the error. The data connections to the full network address queries are working fine.
Since 3 out of 7 of the connections are erroring, the overall dataset won't update through PowerBI.com. I have no way of deleting those data connections, even though they are no longer needed. I don't know why the pbix file is keeping a history of those original file paths, even though I've changed my queries.
I can refresh the data through PowerBI Desktop, because it appears to not be trying to connect to the old mapped network drive paths the way that PowerBI.com is.
I just refreshed the data from within PowerBI Desktop, then went to PowerBI.com and used Get Data to pull it in. Now there are only 4 data sources. I clicked through them, logged in to each one, set up a scheduled refresh, then hit Refresh Now on the Dataset.
SUCCESS!
Thanks for the help.