Forum Discussion
Refresh Excel data model into PowerBI
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.
Community ChampionHi AnneL ,
Did you originally bring the file in by selecting Excel?
You should be able to either click on Refresh in Power BI the third picture, or edit queries and click on refresh in the Power Query Editor. You would then click on Close and Apply as in the first picture.
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
Hi Nathaniel_C ,
Many thanks for replying, I truly appreciate it. No I imported it using power query, as in the first picture. In the data model I'm using you can see the rows are updated till 10/2 (Picture 3). Whereas in PowerBi this is only till 20/9 (picture 2). I am trying to add the last few rows, without having to start from scrach with my dashboards in PowerBI. Both of the refresh buttons you mentioned do not do anything.
Many thanks again!
- Nathaniel_C
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
