Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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, where I created the connections and build a few dashboards.
Now, I have added more data (rows based on date) into the data model and would like to refresh this in PowerBI, so I do not have to import it again and rebuild the dashboard from scratch.
Does anyone know how to refresh an Excel data model in PowerBI.
I am new to PowerBI, so sorry if this is a stupid question, many thanks in advance!
Anne
Solved! Go to Solution.
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @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
Proud to be a Super User!
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!
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
Proud to be a Super User!
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
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
So @AnneL , is there a reason why you imported, rather than getting the data from Excel?
Proud to be a Super User!
@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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.