Forum Discussion
How to Pass Url Parameter from Database
Hi,
How to passing parameter from database in power bi reports
thanks and regards
Herwin
Hi her
It's not clear about your scenario.
According to your information, there may be several scenarios in Power BI:
1. Power BI Service: Filter a report using query string parameters in the URL
Use the url of this format:
URL?filter=Table/Field eq 'value'
- Table and Field names are case-sensitive, value isn't.
- Fields that are hidden from report view can still be filtered.
2. Create a Power BI Slicer Panel and use Bookmarks and Buttons
To get the filter to work as expected, please uncheck the Data option (#5 below) from the bookmark options (ellipsis…) and then clicked on Update (#6 below).
3. use parameters to make your reports dynamic, including :
Using Parameters to Connect to a Data Source,
Adding Parameters to Filter Data,,ect.
Please read reference :
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- parry2k
Super User
her read this post to get your answer quickly
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- v-juanli-msft
Community Support
Hi her
It's not clear about your scenario.
According to your information, there may be several scenarios in Power BI:
1. Power BI Service: Filter a report using query string parameters in the URL
Use the url of this format:
URL?filter=Table/Field eq 'value'
- Table and Field names are case-sensitive, value isn't.
- Fields that are hidden from report view can still be filtered.
2. Create a Power BI Slicer Panel and use Bookmarks and Buttons
To get the filter to work as expected, please uncheck the Data option (#5 below) from the bookmark options (ellipsis…) and then clicked on Update (#6 below).
3. use parameters to make your reports dynamic, including :
Using Parameters to Connect to a Data Source,
Adding Parameters to Filter Data,,ect.
Please read reference :
Power BI Introduction: Working with Parameters in Power BI Desktop —Part 4
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.