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.
- aj1973
Community Champion
Hi 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.
- v-easonf-msft
Community Support
Hi ， Anonymous
If you did not change the excel file and everything is normal when you refresh the report on the desktop, I will suspect that your excel credentials in the gateway have expired. You may need to re-enter your data source credentials, even if it seems to be working fine.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
