Forum Discussion

zrichardson's avatar
zrichardson
Icon for Advocate III rankAdvocate III
9 years ago

OneDrive Excel to OneDrive pbix to Power BI Service

This is my setup:   I have an excel document that is updated on OneDrive Hourly. I have a pbix file that is connected to that excel document that is uploaded to my OneDrive. Finally, I have the Pow...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi zrichardson,

In your sceanrio, it is not possible to sync changes from Power BI Desktop file and Excel file with OneDrive Hourly Refresh at the same time,but you can also set "Schedule Refresh" for your dataset expect OneDrive Refresh.

Thanks,
Lydia Zhang

pntlindsay's avatar
pntlindsay
Frequent Visitor
9 years ago

Hi,

 

I am a bit confused by these answers.  I have a similar issue:

 

1. Excel data file file stroed on onedrive for business

2. Powerbi Pro linked to excel file on Onedrive (using Gt Data > Web >url etc using OAuth2 credentials

3. Power BI Pro pbix stored on Onedrive.

4. Report published to Power BI service

5. Set up scheduled refresh (min update is 24 hours).  Also have Onedrive update (hourly) enabled

 

All good so far, in PowerBI service report has latest data

 

5. Add data to excel file on Onedrive.

6. In PowerBI Pro refresh report and see the latest data

7. In PowerBI Service - refesh but do not see new data

8. Wait an hour and refresh PowerBI service report - still not showing new data

9. I have not yet waited 24 hours to see if hte data is updated in PowerBi service

 

I had assumed that the hourly Onedrive refresh would update data and hence my report.

Is this the case please?  If not is there any way to update the PowerBi service report more frequently than 24 hours?

 

Thanks, Phillip

 

 

I need to use PowerBI Pro, for its additional capability