i connect share point folder, and selected files ,then combine files i find no any check box beside each sheets, please see 1st picture , then i tried get resoure directly to local excel files , i can find checkbox to select 2 or more sheets , please see 2nd picture , so how to fix problem for sharepoint folder
1 ACCEPTED SOLUTION
Hi @KevinGuan ,
Where are you stuck?
You don't need to apply such complex transformations, just click the Transform button to enter the PowerQuery editor when you are in the Navigator:
You will get a raw query. All of our other tables will reference from it, you just need to right click here and uncheck Enable load:
This will result in some duplicate steps, but due to node caching optimizations, they won't actually be repeated more than once, so there's no need to worry about performance.
I've attached the sample file hopefully it will help.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Any one has solution ?
Hi @KevinGuan ,
Where are you stuck?
You don't need to apply such complex transformations, just click the Transform button to enter the PowerQuery editor when you are in the Navigator:
You will get a raw query. All of our other tables will reference from it, you just need to right click here and uncheck Enable load:
This will result in some duplicate steps, but due to node caching optimizations, they won't actually be repeated more than once, so there's no need to worry about performance.
I've attached the sample file hopefully it will help.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Hi, Thanks ，it seems works , but i have another question , what is the difference for duplicate in right menu . i tried this , it also can create another query , can you make a deatil difference between reference and duplicate
Hi @KevinGuan ,
Duplicate: This function creates an identical copy of the original query with separate steps. Changes made to one will not impact the other, making this useful for different configurations or modifications.
Reference: This option links a new query to the original. The new one has a single step that sources from the original. Alterations to the first query will also appear in the referenced one, convenient for making various branches from the original.
Reference vs Duplicate in Power BI; Power Query Back to Basics - RADACAD
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
hello, thanks ,it is very useful link , i learn much from you ,thanks
Click at the top of that group = Parameter1 [38] and transform data. It should load this tables to Power Query and then you can filter.
hello , where is top of that group?,there is no any menu at the top before transform data ,
Hi @KevinGuan ,
I tested it and there is no multi-select box on the navigator. I tested it and there is no multi-select box on the navigator. If you want to filter the combine files, you can insert a filter after the Source step of the query below:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Now you know my question ?
Hello, thanks for suggestion , but i do not want merged files, i want multi-select 2 and more sheets in one files , you can do test again ,select one file, then click combine button in the content column . you will find no checkbox to selected , but if you directly get resource to local excel , you can find checkbox in every sheet , so it was very strange
Hi @KevinGuan ,
There was a bit of a problem with my previous statement, what I was trying to say was also combine files.
If you want to get multiple sheets in an Excel file, you may do so by creating separate queries in accordance with the following instructions. Then combine the tables.
how to import multiple files from folder and keepi... - Microsoft Fabric Community
you can also add this custom column after the Source step (depending on the actual needs to decide whether to use the first row as the header), and then split the query for each table.
Table.Combine(List.Transform(Excel.Workbook([Content])[Data],each Table.PromoteHeaders(_, [PromoteAllScalars=true])))
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
Thanks for more information, it was very good , but there are new question after steps , let us take exmaple , my excel name in sharepoint is Book20240712, and there are 2 sheets named A and B
1, uncheck the loading of the query 1, and i selected sheet B.
2. right click reference , (then renmae query 2 ), i find that sheet is also B , but i want select A , i tried to filter column , there is No sheet A , how to modify ??
hello，i read your post link again , i find something new . i think duplicate query before load would be better , here is my testing according the article.
1. We can uncheck the loading of the original table.The name is Query 1 (selected sheet A)
2.For each table we need, reference the original table and rename it.the name is Query 2 - Reference ,you can change to select sheet B ,(Then i also duplicate the query1 ,the name is Query 2-Duplicate, and i can select sheet B )
3.then i test load all , i find duplicate is good , because i have selected another sheet as picture (sheet B ) , reference is same as original query , you can not select another sheet ,
