power bi report parameter from SQL Table to set default value in report

[amiteshmacq]

is there a way i can access power bi report deployed on power bi services with data driven parameterand set the default slicer/filter value for the report.

Scenario :

power bi report deployed on power bi service is embeded in a web application iframe and data sourse for report is SSAS Tabular. Application user has long list of filter criteria that is stored in SQL Server table with unique ID. Now the requirement is to get the list of filters values from the database table based on unique id column and set the default values for all filters and slicer in the power bi report to give user a personalised view.

[v-janeyg-msft]

Hi, @amiteshmacq 

According to your description,  I suggest you use the new feature:Use DQ connection in composite model.

Reference: DirectQuery for Power BI datasets and Azure Analysis Services (preview) | Microsoft Power BI Blog | ...

When using DQ mode, you can add other data source like your SQL Server table with import mode, then you can create slicer and filter in the report.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.