Forum Discussion

Gjakova's avatar
Gjakova
Post Patron
5 years ago
Solved

Questions about refresh and dynamic data sources

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%20Power%20BI,Contents%20M%20function....
General Comment
Need Help
Tips and Tricks
  • nickyvv's avatar
    nickyvv
    5 years ago

    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.

Gjakova's avatar
Gjakova
Post Patron
5 years ago

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-bi/

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's avatar
nickyvv
Most Valuable Professional
5 years ago

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.