The customer had to teach his other colleagues how to use Power BI to get data from Excel files stored in SharePoint Online. Last week I had a session with one of my customers going through the very same scenario. Navigating the Excel data stored in SharePoint Online Method 2: Getting the Excel File Path Directly from SharePoint (without opening the file in the Excel desktop app) Now you can select tables for sheets and start building your reports in Power BI Desktop. An error raises if we forget to take out the query part from the file path
0 Comments
Leave a Reply. |