Data using a WEB content is noe refreshing after the report is published

[TrulsB]

I have created a report, that get data from a Web. In the Power BI Desktop, it works well when i refresh the data from the source. The source is a API in a web server.   Here is the connection:

After i publish the report to powerbi.microsoft.com, and schedule the refresh - the WEB data is not refreshed.  There is connection to a local Excel spreadsheet (using gateway) in the dataset and this data is refreshed - but not the WEB connection. 

The scheduled update/refreshed is selveral times daily, and works well as planned without any errors.

There is not any errors during the authentication.

Any idea how to WEB connections can be updated in a published report ?

[Anonymous · Accepted solution]

Hi @TrulsB ,

To refresh dynamic data sources in Power BI Service, you can use Web. Contents() and Relative Path parameter in it, please refer:

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code

Setting a scheduled refresh on a Dynamic Data Source in Power BI | by dataninja

It should also be noted that Power BI Service requires https urls for Web data sources to refresh. For non-secured urls (http), it's required to go through the gateway. By design.

So an anonymous API feed using "http" will not allow for a scheduled refresh in the online Power BI service without a gateway. It needs to be an https one.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.