shift from excel with 1 sheet to multiply sheets (PBI)

[Anonymous]

I already have my PBI running,

one of my datasets is an excel file, this file been updating and going to pass the 1M rows limit

I figured a way of split my data to different sheets in this file and avoid the 1M limit.

my problem is I don't know how to move from the Query with the 1 excel with the 1 sheet,

I tried to insert a "step" of getting the new file and append the sheets - but I'm getting an error,

I tried to get the excel as new data and tell the PBI to act like is my old data - also didn't work

thank you

[Anonymous]

Hi,

thank for your help

my foucus is importing data to PowerBi and not to excel.

I know how to use the append method

my problem is that i already have a Query with excel file of 1 sheet and i dnot know how to replace it with my multi sheet excel i want to use

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

Just change the data source of the original query:

Then insert steps after source steps to combine all the worksheets in the excel:

And you need to fix error steps in it , for more details,please refer to https://radacad.com/combine-multiple-or-all-sheets-from-an-excel-file-into-a-power-bi-solution-using-power-query-dynamically

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Ashish_Mathur]

Hi,

See if this video helps - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.