Forum Discussion

Sonam_Pillai's avatar
Sonam_Pillai
Icon for Helper I rankHelper I
7 years ago

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.

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Sonam_Pillai
      Icon for Helper I rankHelper I
      7 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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