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 It might be because Power BI Service doesn’t send Basic Authentication headers with RelativePath. Combine the full URL in Web.Contents, or include the Authorization header with Base64-encoded credentials. Another thing you could try is setting credentials for the exact API endpoint instead of the root domain. I think this is a known limitation, so avoid RelativePath and use full URLs or custom headers for consistency.
Hi, I did set up credentials for the url that requires authentication (multiple api keys for url that share the root, and powerbi only recognises the root at gateway and not the different ones). I created an anchor query mentioning every single url with full path to endpoints. Set all credentials at source settings in desktop. Still, Service doesn't seem to recognize them. Any other approach to test?