Forum Discussion

C097986's avatar
C097986
Icon for Helper I rankHelper I
8 years ago
Solved

Charting Monthly Data from different tables

I am trying to make a chart where i can show a monthly trend. Unfortunately, I get an excel worksheet that has extensive amount of data every month. The data is in the same format every month. I saw ...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    When you choose a folder it gives you a list of files then on the bottom you have Combine,Load , Edit e Cancel.

     

    On the combine you can choose Combine & Edit or Combine & Load.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago

Hi C097986,

 

The best way as you are refering is using the query from folders.

 

Check this link with a complete explanation and try to just follow the steps on PBI.

 

If you have any addtional issues please tell me.

 

Regards,

MFelix

  • C097986's avatar
    C097986
    Icon for Helper I rankHelper I
    8 years ago

    i tried to follow the document but my version of powerbi desktop doesn't let me pick 'combine files' in the querry edit. I updated to the newest version and i still cannot see that option.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      8 years ago

      When you choose a folder it gives you a list of files then on the bottom you have Combine,Load , Edit e Cancel.

       

      On the combine you can choose Combine & Edit or Combine & Load.

       

      Regards,

      MFelix

      • C097986's avatar
        C097986
        Icon for Helper I rankHelper I
        8 years ago

        Now i see what you meant. thank you. this worked. I thought the document was talking about this. but i tried what you said and got it. thank you so much.