![]() So this method is originally discovered by my customer, Mr Callum Fraser. So we thought to look at our options in SharePoint Online, that he found something interesting. He thought, going through all the steps explained in the first method is too much, and it might not be easy for his colleagues to absorb it. 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. 36K views 1 year ago All quick tip videos for Microsoft Education features This step-by-step tutorial will show you 11 new features in Excel Online for 2021. ![]() 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) Example use areas: Data analytics Project management Finance and accounting Test Yourself With Exercises Excel Exercise: Complete the Excel formula: 1+1 Submit Answer ยป Start the Exercise My Learning Track your progress with the free 'My Learning' program here at W3Schools. ![]() Now you can select tables for sheets and start building your reports in Power BI Desktop. Excel is the worlds most used spreadsheet program. An error raises if we forget to take out the query part from the file path ![]()
0 Comments
Leave a Reply. |