Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Power bi reports using parameters to create SQL queries and displaying the results.

Hi, I have drop down lists from imported SQL data tables to choose parameters in Power bi. I would like to place these parameters in a SQL query to query the tables or send the parameters back to SQ...
Need Help
ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
1 year ago

Sorry, but this did not help me understand what you are trying to do. Can you show us a picture of what this means:

"I have drop down lists from imported SQL data tables"

What is in this data? Names of tables? Or actual table data?

Anonymous's avatar
Anonymous
Not applicable
1 year ago

 Names of tables? Or actual table data? - actual table data

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Anonymous 

    You can refer to the solution i offered above, create a dynamic paramater, then use the paramater in sql query, it can return the related result.

     

    Best Regards!

    Yolo Zhu