cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pedromooji Regular Visitor
Regular Visitor

file import from excel files

Hi guys,

I'm trying this:

I have all my data in excel. All the tables and queries. 

In power bi, goto File, Import and Excel Worbook contents. After that, i will upload to your pbi file all tables and queries. You don't have an option, unfortunatly, to choose what do you want.

But my question is this:

If i change something in my excel file, like the main table with just the records from this month, when i open the pbi i can see the records from all months. I must be doing something wrong. I though by refreshing (Home - Refresh) it would be enough but it's not. Also, in Home - Edit queries, there's another option, Refresh Preview. I always do Refresh All. Still nothing happens.

So my question remains: how to refresh the connections, how to refresh all my queries from excel? And yes i did save my excel file first (lol)

Thank you so much for your help

Pedro

3 REPLIES 3
Highlighted
rafaelmpsantos Established Member
Established Member

Re: file import from excel files

Can you send us some picture of one example? When you select only the data from this month are you doing this using filters in excel, or deleting the data from another months?

Community Support Team
Community Support Team

Re: file import from excel files

Hi pedromooji,

 

"If i change something in my excel file, like the main table with just the records from this month, when i open the pbi i can see the records from all months. I must be doing something wrong."

 

<--- Could you share some more details about what have you done in your excel and power query? Some screenshots will be much appreciated.

 

Regards,

Jimmy Tao

pedromooji Regular Visitor
Regular Visitor

Re: file import from excel files

Guys, 

Many thanks for your answers but if you need more info on this it means you didn't try it so far. Therefor, unfortunatly for me, you can't help me.

Thanks anyway