How to use only one source file for multiple Raw data sheet in POWER BI

[Sonam_Pillai]

Hi,

So i am working on a POWER BI and creating a dashboard.

I have a excel worksheet which i link to every raw data with different condition.

For E.G.

RAW data File A-  Source File XYZ (Filter one criteria)

RAW data File B-  Source File XYZ (Filter another criteria)

RAW data File C-  Source File XYZ  (Filter another differnet criteria)

How can i use source File XYZ for all the Raw data files with different criteria.

[CheenuSing]

Hi @Sonam_Pillai 

Need more information on your query. Is it a singe excel workbook and singale sheet in that work book and you want to extract it as 3 different tables into Power Bi based on condition ?

Cheers

CheeunSing

[Sonam_Pillai]

So I have multiple raw data files which i used to create reports.

I have one excel file which i use for a connection based of the different criteria.

like for e.g. 

i have a raw data file Name Client Details, Sales Details, Profit details etc and i have one excel file named 'Criteria file'

which i use for all the raw data files. it works like a vlookup. it creates a connection.

so for all the raw data, I use  'Criteria file' to get the regions.

[CheenuSing]

Hi @Sonam_Pillai 

Please share your data and what is the output expected to googledrive / onedrive and share the link to arrive at a solution.

Cheers

CheenuSing

[Sonam_Pillai]

Here is the link

https://1drv.ms/u/s!AloDMVO86GTKZ8Vv_vft-QSj_hw?e=7kXANl

data 1 and data 2 are the raw data file and source file is the one which we connect to every raw data file based on the ciriteria, it works as a Vlookup.