can PowerBI have SSRS type parameters that are loaded via query?

[handi]

As a SSRS developer long ago, we had reports with many parameters in the report header area. Each were loaded with various TSQL queries, such as a parameter with all the Divisions, Departments, etc... After chosing the required parameters from the dropdown lists, they were used for the report's main query.

Can Power BI load each parameter with seperate TSQL queries to be used by the final main query?

I can only find examples of static methods using lists or an excel file to populate the parameter, which would need to be edited eventually.
I'm new to Power BI but I can't imagine this not being possible for dynamic Power BI reports.

A simple yes or no will help, but a guide (link) would be great.

Thanks

[rajendraongole1 · Accepted solution]

Hi @handi -Yes, Power BI can load parameters dynamically using SQL queries, though it's slightly different from how SSRS handles it. In Power BI, you can use Power Query to define parameters and dynamically populate them with SQL queries.

process flow:Go to Power Query Editor in Power BI Desktop>>In the "Home" tab, click on Manage Parameters > New Parameter>>Define your parameters and their values, which can be dynamic based on the SQL query.

youtube and documentation links:

Parameters - Power Query | Microsoft Learn

How to use Query Parameters for Dynamic Reports in POWER BI (youtube.com)

[handi]

Excellent!
That video is a great tutorial & I went ahead and subscribed to her YT channel. It looks like she has lots informative videos.

Thanks rejendraongle