We have many Excel files on SharePoint Online Document Libraries - well structured and maintained and refreshed. It would be great to be able to point to those directly. The OneDrive for Business i...
The only real viable option which works at the moment is to use Excel. The Data Query allows from SharePoint Folder. Once you have built the Query you want, save the Workbook. Open Power BI Desktop and import Excel File. This will then create the Query for you connected to SharePoint Document Library. You can then work from there. The Query appears to be = SharePoint.Files("https://Tenant/sites/", [ApiVersion = 15])
