Forum Discussion
Network drive - 'unable to connect to data source undefined' error
Hey, v-easonf-msft
I got it to work by switching from using the Folder connector to using the Excel connector in Power Query instead. I also re-entered my credentials like you suggested. Thanks!
v-easonf-msft - thanks, but I've just checked, and everything works fine on Power BI Desktop/Power Query. That goes both for my original pbix file and when I download the report from the service. I'm only seeing the error message in the web portal. However, when I try to re-publish my report to the Power BI Service, my visualizations are showing new data as expected even though I still see the error. What I need help with is ensuring scheduled refresh starts working again, as now it's disabled after 2-3 refreshes fail.
PS: For clarification I am keeping my data model and my report with visualizations in two separate pbix files. I am using the Power BI dataset connector in my report, in order to keep it up-to-date with the newest data.
Community ChampionHi Anonymous
The Gateway is somehow sensitive to manual changes every now and some mismatch can occure down the path. I suggest that first you update your Gateway, Publish your report into a new workspace and use the Gateway to manually refresh it. If all is good then check by elimination what is going wrong in the previous Workspace and correct it if you still want to use it.