Forum Discussion
power bi report parameter from SQL Table to set default value in report
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.
1 Reply
- v-janeyg-msft
Community Support
Hi, amiteshmacq
According to your description, I suggest you use the new feature:Use DQ connection in composite model.
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.
