Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello
I have setup a report utilzing and html report from SAP that I am receiving every morning. And so far there has been no problem in powerbi with manually saving the html file on the common drive an loading from there. However utilising this approach I have to manually save it and/or be on site with open computer.
By setting up a powerautomate flow I can transfer the file in the cloud to our sharepoint. However when loading the html file from sharepoint Power BI fails to be able to pull the data. The PowerBI having issues getting data from htm file on sharepoint with 4 tables in. The htm file on sharepoint looks graphically fine with 4 tables in. But when getting data through powerbi find the file name as binary data, but powerBI cannot read table 1-4.
Its not due to file modification on sharepoint since we can download the file and use it from desktop/commondrive/onedrive again.
How do i solve it so that I can use a html file on sharepoint as the datasource for Powerbi?
( ihave tried both getting data directly from fil via "web" and by linking and filtering down through the sharepoint folder option.)
Best regards
Jesper
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.