Forum Discussion

bmoles's avatar
bmoles
Regular Visitor
9 years ago

Refresh Now and Scheduled Refresh Not Working

We have an Excel spreadsheet with few Pivot Tables reporting data from PowerPivot which data source is an Azure SQL database. The file is saved on a SharePoint Online library. This report was working...
Reports
bmoles's avatar
bmoles
Regular Visitor
9 years ago

After successfully testing that the report could refresh (with the "Refresh now" button) I realized that the PowerBI service doesn't allow to schedule a refresh if its data source's credentials are not previously updated which in turn prevent the report from refreshing again.

 

Previous tests were done with a spreadsheet which had the login credentials saved in it. This meant that there was no need to enter user and password to refresh the report. 

 

We did additional tests and shaw that removing the credentials on the spreadsheet had the following effects:

  1. Excel 2016 (on laptop) requests user and password to fresh data locally
  2. If the spreadsheet is uploaded to OneDrive and connected from PowerBI service the message "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again." appears as before. Withoug updating credentials we check the following:
    1. The "Refresh now" on PoweBI finishes without errors and without asking for credentials.
    2. Excel Online is also able to refresh the report without asking for credentials.
    3. Scheduled refresh cannot be enabled.
  3. After updating credentials the reports fail while refreshing (through PowerBI'S "Refresh now" and "Scheduled Refresh" and through Excel Online.

 

Can any one explain why Excel Online is able to refresh the report without being the credentials stored within while the local Excel cannot?

 

Thanks,