Forum Discussion

MrDaniels's avatar
MrDaniels
Frequent Visitor
3 years ago

Unable to refresh power query data source. Scheduled refresh is disabled (Credentials)

Hi gurus,

 

I have created a report using Power Query connected to a SQL Server Analysis Cube.

 

On my desktop PBI I can refresh the data source with no problem.

 

Once I publish the report into PBI Services, does not let me. It says:  Scheduled refresh is disabled because at least one data source is missing credentials.

 

When I try to check the credentials only gives me this option:

 

which once I select sign in does not do anything, just thinking for ever.

 

Not sure why my credentials are not working anymore the moment I Publish the report? any suggestion.

 

I need to update the Power Query.

 

Thanks in advance.

2 Replies

  • In the workspace go to the settings page for the dataset and then update the credentials there.

    • MrDaniels's avatar
      MrDaniels
      Frequent Visitor

      Hi lbendlin , I wish were that easy. Please read my post. I've already try.

       

      Cheers.