Forum Discussion

Arnoh's avatar
Arnoh
Helper III
1 year ago
Solved

Power BI Service not sending Basic Authentication with Web.Contents using RelativePath

Hi everyone, I have a dataset in Power BI Desktop that uses the following M code to retrieve paginated data from the API. It works perfectly in Desktop — all pages are fetched using Web.Contents wit...
  • rohit1991's avatar
    1 year ago

    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.

     

  • Arnoh's avatar
    1 year ago

    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.