HOW TO COMBINE MULTIPLE FOLDERS IN POWER BI | COMBINE MULTIPLE FOLDERS IN A SINGLE QUERY -POWER BI

In This Video -
- How do I combine multiple folders into one?
- How to process multiple folders with a single Power Query script

Get Help into Questions Related to #powerbi , #dax , #powerquery Power BI #datamodeling , #analysisservices and #powerbiservice

Checkout our playlist and SUBSCRIBE to our channel, for all such interesting topics in Power BI.

Follow us on LinkedIn
@POWERBIHELPLINE

[osunbxu]

HI, How to schedule autorefresh for combined data folders data. I am using Power BI desktop and use Report servers to publish reports. This merged folders data path doesn't appear under Manage Data location. #powerbi , #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice

[osunbxu]

Hi, I successfully combined various folders files. But this table is not appearing in my 'Report Server' - Data Manage section. I am trying to schedule auto refresh. Whereas it appears in Pbix. Please help.

[premprakash]

How can we also combine a specific sheet out these files, rest of the scenario is same.

So let's say I have country folders and year's subfolders and these subfolder's has files with multiple sheets out of which I only want pick one.

The file definitely consists a word let's say "data".

Could you please help?

[osunbxu]

Hi, I am trying to extracy multiple .csv files from 7 folders and combine data of all csv files. I am using Csv.document(content) it increases the file size dramatically...and its not loading...can you please suggest some solution.

[pavanwipro]

I have multiple files for various categories stored in the folders with month names. I want the data to be combined for each category and then export the data to a seperate excel for the last 2 weeks data. How to achieve this?

[architraj]

It is showing an error in the last step saying ExpressioneError: Illegal characters in path. How should I fix this?

[pascaljoly]

this works but if you delete a folder and try to refresh the query, it doesn't work anymore, you can add more folders and they will get added to the query but you can't delete any. when i try i get an error message (We cannot convert null value to type text). is there a fix? I don't want to have to recreate the query each time.

[sasidharreddykomatla]

How to load different formatted files in a single folder.