Forum Discussion
Power BI Service not sending Basic Authentication with Web.Contents using RelativePath
Hi Arnoh ,
Great to hear you identified the root cause! When visuals show “Visual has pending changes” and require manual refreshing after a dataset update, it’s often due to the "Pause visuals" setting under the Optimization pane being enabled. This feature is helpful when working with large models or making several changes, as it temporarily suspends visual updates for performance, but can be confusing if toggled unintentionally. If anyone else encounters this issue, simply go to the “Optimize” ribbon in Power BI Desktop and uncheck “Pause visuals.” Once deselected, your visuals will resume auto-refreshing as expected after dataset updates. Also, keeping Power BI Desktop updated and clearing the cache occasionally can help avoid unexpected behavior.Hi it seems to be an issue in the power bi service. But there is a workaround you can make a connection inside the power bi service instead of entering the credintials in the workspace.
Hi Arnoh ,
Great to hear you identified the root cause! When visuals show “Visual has pending changes” and require manual refreshing after a dataset update, it’s often due to the "Pause visuals" setting under the Optimization pane being enabled. This feature is helpful when working with large models or making several changes, as it temporarily suspends visual updates for performance, but can be confusing if toggled unintentionally. If anyone else encounters this issue, simply go to the “Optimize” ribbon in Power BI Desktop and uncheck “Pause visuals.” Once deselected, your visuals will resume auto-refreshing as expected after dataset updates. Also, keeping Power BI Desktop updated and clearing the cache occasionally can help avoid unexpected behavior.
Has any body found a working solution yet?
I am having a similar issue.
In my case, apikey authentication needs to be passed at
https://app.xxxxx.com/api/company1
Or https://app.xxxxx.com/api/company2
Because I have to combine data from multiple sources that require different API keys.
I overcome the dynamic URL issue that prevented refresh by using webcontents instead of Baseurl, and the relative path approach.
My dataset contains many many endpoints. Fx. https://app.xxxxx.com/api/company1/employees
Per each of the companies I am joining in the model.
I started getting the error of missing credentials at root, so I set it as Anonimous.
Now I am getting the error of missing credentials at end point, so I created a query to use as anchor mentioning every single url I use in the model. Not ideal because I need to remember to add new endpoints if I ever need one extra, and they are already a lot!
I then defined credentials in Source settings in desktop for each of this endpoints, which now appear in the sources list (they inherited password from the sources I already had for https://app.xxxxx.com/api/company1 anyways
Well ... it is not working.... it still claims credentials are missing for each endpoint url. I already set the root test to skip, which is the only url recognised at Gateway.
Any other ideas?