Forum Discussion

granthworth's avatar
granthworth
Kudo Kingpin
8 years ago
Solved

I want Calculated Columns and OneDrive Refresh

...but I can't have them, which is beyond frustrating. If I want hourly OneDrive refresh (24 times a day versus 8), I have to connect to my Excel files in the PBI Service which means I can't use calc...
  • Anonymous's avatar
    Anonymous
    8 years ago

    granthworth,

    Yes. When you directly upload the PBIX file to Power BI Service and turn on OneDrive refresh, and change the data in Excel file data source, the data can't be updated in Power BI dataset/report hourly.

    However, you can set schedule refresh for the dataset, as your post, up to 8 times for pro user. If you want to refresh 24 times a day, you can purchase Power BI premium license, which allows you set schedule refresh up to 48 times a day.

    Regards,
    Lydia