Forum Discussion
Unable to create Excel workbook dataflow - Unexpected error
I am currently trying to set up a number of dataflows to Excel workbooks stored on a Sharepoint site (or OneDrive). I have set up a brand new PPU workspace (and have also tried a standard Pro workspa...
Hi Anonymous ,
This seems to be a problem with your file path or URL.
When you want to get a link URL from Excel, you will need to first navigate to your OneDrive for Business location using your browser. Right-click on the file you want to use and select Open in Excel. Then In Excel, select File > Info, and then select the Copy path button.
For more details, you can refer to:Use OneDrive for Business links in Power BI Desktop
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.