cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnneL Frequent Visitor
Frequent Visitor

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, 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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: 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.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




View solution in original post

8 REPLIES 8
Nathaniel_C Super Contributor
Super Contributor

Re: Refresh Excel data model into PowerBI

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

file.PNG

 

file1.PNG

 

file2.PNG

 

AnneL Frequent Visitor
Frequent Visitor

Re: Refresh Excel data model into PowerBI

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!

PB1.pngPB2.pngPB3.png

Nathaniel_C Super Contributor
Super Contributor

Re: Refresh Excel data model into PowerBI

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 Frequent Visitor
Frequent Visitor

Re: Refresh Excel data model into PowerBI

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 Super Contributor
Super Contributor

Re: Refresh Excel data model into PowerBI

Hi @AnneL ,

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

Nathaniel

Highlighted
Super User
Super User

Re: 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.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




View solution in original post

Nathaniel_C Super Contributor
Super Contributor

Re: Refresh Excel data model into PowerBI

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

 

 

AnneL Frequent Visitor
Frequent Visitor

Re: Refresh Excel data model into PowerBI

@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!

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 184 members 1,712 guests
Please welcome our newest community members: