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 documentation ( https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links ) and am having some issues.

 

The first issue I noticed is that I did not get any option for the "hourly" refresh that is touted with OneDrive use in PBI. There was also no message or text anywhere stating this was the case. Upon investigating, I saw that the authentication method for all 7 files in the PBI service was set to "Anonymous" even though I had initially set them all to "OAuth2" per PBI documentation. When I changed them to OAuth2 again, I noticed that this setting does not save and they immediately go back to the Anonymous authentication.

 

Could this be the reason I am not seeing the hourly refresh and if so, how can I fix it? Thank you!

Need Help

8 Replies

  • 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