Forum Discussion
Refresh: external excel source
Hello,
I have an issue with Power Query editor. When I open my Pewer BI Desktop and go to Power Query Editor, each time I see:
DataSource.Error: Could not find a part of the path 'T:\_SCH\xxxxxxx.xlsm'.
Szczegóły:
When I click few times on "Refresh it works. Then I need to refresh each tables separately. I tried to replace disc name "T" on server name- sill the sam....How can I improve this?
Thanks!
Hi akinom_84 ,
Please click the File->Options and Settings->Data Source Settings to check / Re-enter the file path as right format carefully .
Or maybe you need to upgrade your Power BI Desktop to the latest version.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn Qin
5 Replies
akinom_84 I guess the troble you are facing because you are importing data from xlsm (macro enabled files). Please refer to below links for solution
If you can't find solution, please revert back.
Hi akinom_84 ,
Please click the File->Options and Settings->Data Source Settings to check / Re-enter the file path as right format carefully .
Or maybe you need to upgrade your Power BI Desktop to the latest version.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn QinHi akinom_84 ,
Sorry to disturb you...
But did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.Best Regards,
Eyelyn QinEyelyn,
thanks for reply. I replaced source path from letter to full server name and it works.
Ragards,
Monika
But don't understand why letter doesn't work, if my other/previous build PowerBI applications doesn't have such issue.... 🙂
