Forum Discussion

RitaPT's avatar
RitaPT
Frequent Visitor
9 years ago
Solved

Update data model from Power Pivot

I built a data model in Power Pivots and after I imported to Power BI. Next I made reports and dashboards and I shared with my clients. Everything was ok but with the time we understood that I need t...
Need Help
  • Anonymous's avatar
    Anonymous
    9 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

Anonymous's avatar
Anonymous
Not applicable
9 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

RitaPT's avatar
RitaPT
Frequent Visitor
9 years ago

Thanks a lot Anonymous. I made a test with OneDrive as you mention and it update my data model.
Your help was very helpful.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    RitaPT,


    Please help to mark my reply as answer if it solves your issue. That way, other community members would easily find the solution when they get same issues.

    Thanks,
    Lydia Zhang

    • RitaPT's avatar
      RitaPT
      Frequent Visitor
      9 years ago

      Excuse me, one more questions. Do you know if this option is only available to Power BI Pro or also for Free Power BI?

      Thanks.