Forum Discussion
Error refreshing data in Power BI
Hello,
I would like to ask what's wrong in refreshing data in Power BI. I published a report in PBI Service but getting this message of error:
I have no idea how to resolve this. I can't set up schedule refresh.
In data source settings I see this:
Hi, that's an usual message for connections to web pages or web apis. As you can see in your second picture, it says at the bottom that it might not list the one with the issue there.
Be sure to go to edit queries and check if you are connecting to a web. The source step might be using web.contents or web.browsercontents.
Once you find it you can usually fix it following this practices https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
However not all dynamic data sources in power query can be fixed. We'll see.
I hope that helps,
1 Reply
Hi, that's an usual message for connections to web pages or web apis. As you can see in your second picture, it says at the bottom that it might not list the one with the issue there.
Be sure to go to edit queries and check if you are connecting to a web. The source step might be using web.contents or web.browsercontents.
Once you find it you can usually fix it following this practices https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
However not all dynamic data sources in power query can be fixed. We'll see.
I hope that helps,