Solved: Connect Excel located in Web

sabedin · ‎02-08-2017

Hello,

Is there any possibility to connect Power BI with an Excel file located in a webpage?

Thank you

Sabedin

v-qiuyu-msft · ‎02-09-2017

If you mean embed the Excel in a web page use the method in this article: Share it: Embed an Excel workbook on your web page or blog from OneDrive. Based on my test, it's not supported to extract the Excel data, it just only get the HTML elements.

I would suggest you store the Excel in OneDrive, then get data from the Excel in desktop? Use OneDrive for Business links in Power BI Desktop

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-qiuyu-msft · ‎02-09-2017

Hi @sabedin,

If you mean embed the Excel in a web page use the method in this article: Share it: Embed an Excel workbook on your web page or blog from OneDrive. Based on my test, it's not supported to extract the Excel data, it just only get the HTML elements.

I would suggest you store the Excel in OneDrive, then get data from the Excel in desktop? Use OneDrive for Business links in Power BI Desktop

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.