Refresh: external excel source

[akinom_84]

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!

[akinom_84]

But don't understand why letter doesn't work, if my other/previous build PowerBI applications doesn't have such issue.... 🙂

[akinom_84]

Eyelyn,

thanks for reply. I replaced source path from letter to full server name and it works. 

Ragards,

Monika

[Anonymous]

Hi @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 Qin

[Anonymous · Accepted solution]

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

[negi007]

@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

https://community.powerbi.com/t5/Desktop/Trouble-importing-data-from-Excel-macro-enabled-file-xlsm/t....

If you can't find solution, please revert back.