Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Need Help

3 Replies

  • rafaelmpsantos's avatar
    rafaelmpsantos
    Icon for Responsive Resident rankResponsive Resident
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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