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.

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

Hi AnneL ,

 

See this...REFRESH

 

From this it seems like it is a point in time snapshot.  Refresh the underlying data first.

 


Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

AnneL's avatar
AnneL
New Member
6 years ago

Hi Nathaniel_C ,

 

Thanks for answering again. I have came across that article already and read it a few times. You are right that it is a screenshot and I need to refresh the underlying data. However, I just can't figure out how to do it. Is it even possible to do this when importing via Power Query, or should I have just imported it via Excel instead of the data model?

 

Many thanks again, it is appreciated!

 

Anne

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi AnneL ,

    We need to reach out to ImkeF , who is a wiz at Power Query.

    Nathaniel

    • 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?