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 have multiple Excel files, each contain two sheets (Sheet A and Sheet B). I have performed power query on the Sheet A and made a dashboard on page 1 in Power Bi. How to make power query on Sheet B and make its dashboard on page 2? Any help given is appreciated, thank you.
Solved! Go to Solution.
Hi @Anonymous ,
1. Select the Combine Files--> Select Sheet 1
2. For Sheet 2, you could right-click the query to duplicate the query , remove all steps after #"Invoke Custom Function2", then still Select the Combine Files , and select Sheet 2 instead.
If you mean you want to automatically navigate to the Page X to create visuals based on Sheet X, I think it's not possible since report pages need to be manaully created, and then you can add visuals based on the tables you want.
For more information, please refer to:
Power Query Folder connector - Power Query | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
1. Select the Combine Files--> Select Sheet 1
2. For Sheet 2, you could right-click the query to duplicate the query , remove all steps after #"Invoke Custom Function2", then still Select the Combine Files , and select Sheet 2 instead.
If you mean you want to automatically navigate to the Page X to create visuals based on Sheet X, I think it's not possible since report pages need to be manaully created, and then you can add visuals based on the tables you want.
For more information, please refer to:
Power Query Folder connector - Power Query | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Are you using folder connector to connect to multiple Excel files in a folder?
When combine files, you get the display for selecting your sheets on the basis of a sample file. See below. Here, you can select Sheet2.
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.