Forum Discussion

granthworth's avatar
granthworth
Kudo Kingpin
8 years ago

OAuth2 reverting back to Anonymous - OneDrive Excel File

Hello,   I recently updloaded a PBI desktop file to the service that uses 7 different Excel workbooks stored in OneDrive for Business as the data source. I connected all of them per the documentati...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

granthworth,

The issue is not related to the authentication. In your scenario, you would need to upload the Power BI Desktop file to OneDrive for Bussiness, then use "Gate Data->Files->OneDrive-Business" entry in Power BI Service to connect to the PBIX file, this way, you will see OneDrive Refresh(hourly refresh) option.

Regards,
Lydia

  • granthworth's avatar
    granthworth
    Kudo Kingpin
    8 years ago

    Anonymous

     

    Hi Lydia,

    Thank you for your reply. I have since uploaded the .pbix file to OneDrive for Business and added it to another workspace in the Power BI service via "Get Data" in the PBI service. I now see the "Onedrive refresh" option which I have turned on. Now my question is...will this connection "pull-through" the .pbix file to retrieve the refreshed data from the Excel files also stored on OneDrive?

     

    This is the current structure:

     

    Excel files (the data changes here - these files contain the updated data) stored in OneDrive and imported into .pbix desktop file via Web link > .pbix file also stored in Onedrive > Imported the .pbix file into PBI service via "Get Data" with OneDrive refresh enabled

     

    So technically, we are telling the PBI service to refresh the .pbix file, not the Excel files. Does this type of connection extend through to the data source Excel files and query for updated data even though we aren't directly refreshing them through the PBI service?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      granthworth,

      In your current scenario, when you add new measures, change column names, or edit visualizations in Power BI Desktop file, once you save, those changes will be updated in Power BI within about an hour. Data changes in Excel source file will not updated in Power BI Service unless you click Refresh now or set up a refresh schedule by using Schedule Refresh.

      Reference:
      https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive

      Regards,
      Lydia