file import from excel files

[Anonymous]

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

[v-yuta-msft]

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

[rafaelmpsantos]

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?

[Anonymous]

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