Forum Discussion
Network drive - 'unable to connect to data source undefined' error
- Anonymous5 years ago
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.
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.