IN conditions from sheet excel

[Anonymous]

Hi all!,

it's possibile in Power BI runs a query ( from a Oracle DataSource)  with a "where clause" that read from a sheet Excel?

For example, my situation is the following:

• Build a Dashboard,istograms and pie charts  with a query on Oracle DB like this --> 
  select * from <table_name> where <input_list> in <Sheet_Excel>

thank's you All

[v-lili6-msft]

hi, @Anonymous 

You could get it as below:

Step1:

get data from <Sheet_Excel>

Step2:

Transform the Sheet_Excel as New Query

Step3:

Now add a parameter based on the new query

Now, you could use this parameter in query on Oracle DB as the article

https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

Best Regards,

Lin

[Anonymous]

Thank's Lin... I'll try... Keep in touch!!

[v-lili6-msft]

hi, @Anonymous 

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin