![]() ![]() For your purposes, of course, replace the names and addresses - marked in red. It is much better to write a short code in M, and the connection is simple, clear and functional. In addition to the complexity, it has the disadvantage that custom features may not work properly when updating in the cloud, even if they work on Desktop. This works, but it creates a complicated structure of queries with a custom function. One option is to go through Get Data / SharePoint Folder / Combine and Edit /. There is no need to install the Gateway and the data is allways available in the SharePoint cloud - accessible for the cloud. It's possible to use a shared disk or server, but if your company has at least one SharePoint Online account, it's probably easier to have the file in the SharePoint document library. ![]() If the file is on your computer, Power BI will only reach it when you're connected, and you also need a Gateway installed on your computer. If you want to use Excel as a datasource for Power BI, it is not that easy. Why should you connect Power BI to an Excel file on SharePoint? This article describes, how to simply use a xlsx file on SharePoint as a datasource for Power BI. ![]() How to simply connect Power BI to Excel file stored on SharePoint
0 Comments
Leave a Reply. |