cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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.

 

4 REPLIES 4
Super User I
Super User I

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

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
Helper I
Helper I

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

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.

Highlighted
Super User I
Super User I

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

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

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Highlighted
Helper I
Helper I

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

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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors