How to merge numerous tables into one for different customers?

[Matheuspeppers]

Hi guys, how are you?

I would really like some help that I'm breaking my head.

I need to make a dashboard that consists of showing the indicators of 7 customers, the information that will be shown will be the same. However, I need to make it so that I can show the overall result of all, and also create a filter of each one to see separately.

Each client has 3 Facebook Ads databases, in which the ad ID is similar in all 3. It is because one gives me all the results, but with age, another with region, and another with platform. In other words, I need to also join all 3 bases together to form one.

One way I thought of doing this productively is to gather all the bases in a folder and import them into Power BI by folder and then do the merge. But it is not working, because it is not bringing me a table with the file name so I can separate each client.

Does anyone know a productive and functional way to do this?

I wanted to avoid uploading each client as a different table, so I don't need to make the same measurements several times. I wanted to make a single measure for everyone and then be able to filter by customer.

[Adel]

You could get all this data using a tool like windsor.ai
https://windsor.ai/how-to-connect-facebook-ads-to-power-bi/
and then add a slicer in the dashboard to filter by client using this field ( https://windsor.ai/connector/facebook/#account_id / https://windsor.ai/connector/facebook/#account_name) 

[Greg_Deckler]

@Matheuspeppers So, the Folder query should preserve the file name in a column called Source.Name. See attached PBIX below signature. What version of Power BI Desktop are you on? 

[Matheuspeppers]

I can't open your file because I don't have the data source (in this case the folder), here on my machine.

[Greg_Deckler]

@Matheuspeppers You can open the file. You won't be able to refresh but you can at least open the file and look at the data. It is import mode. If you really need the data. I have attached them here and they were in a file C:\temp\Folder. I updated the PBIX to point there. (attached below)

[Greg_Deckler]

@Matheuspeppers Here is the 3rd Excel file (only allows 3 attachments)

[Matheuspeppers]

My version is the latest.