Forum Discussion

AnneL's avatar
AnneL
New Member
6 years ago
Solved

Refresh Excel data model into PowerBI

Hi!   After hours of searching and trying I decided to come here for help. I have created a query in Excel, wich I have imported into the Excel data model. This data model is imported into PowerBI,...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    There is no connection any more between your Excel File and Power BI. 

    After you've imported it to Power BI, these files are independent from each other.

     

    If you want to run one central model and consume it with different clients, you should publish the model in Power BI service and consume from there. Just update that model in the service to "push" all changes to the consuming models.

ImkeF's avatar
ImkeF
Community Champion
6 years ago

There is no connection any more between your Excel File and Power BI. 

After you've imported it to Power BI, these files are independent from each other.

 

If you want to run one central model and consume it with different clients, you should publish the model in Power BI service and consume from there. Just update that model in the service to "push" all changes to the consuming models.

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

So AnneL , is there a reason why you imported, rather than getting the data from Excel?

 

 

  • AnneL's avatar
    AnneL
    New Member
    6 years ago

    Nathaniel_C , just beceause I already created a calander table in Excel to report different relationships and to have more options with analzying and it is easier to add data I think. I will continue working in Power BI, create a calendar table there and just use the import function as ImkeF mentioned.

     

    Thanks for helping out!