Forum Discussion
Update data model from Power Pivot
- Anonymous9 years ago
Hi RitaPT,
Do you import the Excel workbook that contains Power Pivot model into Power BI Service?
If so, according to this article, when you refresh a dataset created from an Excel workbook imported from a local drive, only the data queried from data sources is refreshed. If you change the structure of the data model in Excel or Power Pivot, you’ll need to re-upload the workbook. If you expect to make regular changes to the structure of your workbook and you want those to be reflected in the dataset in Power BI without having to re-upload, consider putting your workbook on OneDrive. And if you connect to external data sources in Power Pivot, a gateway is required in order to refresh your dataset.
Thanks,
Lydia Zhang
Hi RitaPT,
When using gateway, Power BI pro license is required.
Thanks,
Lydia Zhang