Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 several threads on this and tried all the suggestions such as appending querries, made a folder querry and manually adding the data in one worksheet but the data is soo much that it seems impractical to manually add the data together. Is there another option to trend monthly data that come from different tables?
any suggestions are appreciated.
Thank you
I did have trouble mkaing folder querries so i might have messed up in it. can someone guide me how to do that correctly, please?
Solved! Go to Solution.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsi 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.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsNow 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |