Two pages from one excel file of two sheets

[Anonymous]

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.

[Anonymous · Accepted solution]

Hi @Anonymous ,

• Firstly, as @Vijay_A_Verma metioned, you could put all excel files in a Folder. Then follow:

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.

• In addition,based on this How to make power query on Sheet B and make its dashboard on page 2?

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.

[Vijay_A_Verma]

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.