Questions about refresh and dynamic data sources

[Gjakova]

Can someone give me perhaps some clarification on the following? https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#:~:text=In%20most%20cases%2C%20P....

I'm getting this message and according to the documentation I read, there is no way to set up a refresh?

My questions are:
1. Is it only when you want to set up a scheduled refresh? Does a manual one work?

2. Is there a way to work around this using RelativePath etc. (what I read in the documentation)

2a: Does the workaround always work or only some certain sources?

Thanks in advance 😉

[nickyvv]

Hi Gjakova,

1. this limitation is indeed only for the service.
2. Can you elaborate more on what you are using? Can you share the M code or at least the data source you have?

[Gjakova]

Hi @nickyvv thanks for your comment.

Due to it being private data, I made it anonymous. Here is the link to my script: /

I read the following blogs:

- http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/

- https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...

But since I never worked with these types of API's and since this dashboard was developed by someone else, I am having a hard time understanding it. Hope you can help!

[nickyvv · Accepted solution]

Thanks @Gjakova, for the prompt reply.

The 2nd link to Chris Webb's post should help you.

You'll especially have to adjust this URL to become static (so don't use parameters in the base URL) as Chris mentions:

     url=#"HR2day URL"&"/services/apexrest/hr2d/elektricity?wg=KEY123~KEY345~KEY678",

On another note: I see you are using the SalesForce API, you could also use one of the built-in Salesforce connectors, I assume you want to use the Salesforce Reports connector.