Import Excel from web function (.ashx)

[donaldo]

Hi all,

I have an internal tool / website with a link that will prompt a download for an Excel worksheet (.xlsx). The link behind looks like this http://fpp.website.net/Projects4.ashx.

It takes some time for this service to generate the report, varies between 30 seconds to a couple of minutes. 

I've tried the Web data source connector in Power BI, but it just seems to spin forever and never resolve. The Excel connector doesn't handle weblinks.

Is there a way to import this worksheet into Power BI?

[v-lili6-msft]

hi, @donaldo

You may try to update power bi desktop to the latest version (2.65.5313.841 64-bit (December 2018)), then try to get data by

Web connector.

https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/

You may try to use API to get the data.

https://docs.microsoft.com/en-us/power-bi/report-server/rest-api

http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

Also you could use another database as a staging point then get data from it.

Best Regards,

Lin