Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear experts,
I recently learnt how to pass filters into URL using ?filter=tablename/columnname eq 'value'
Can someone help me if there is a way to pass the sheet name as well into the URL?
so that i can navigate to a specified sheet by passing into the URL itself.
Thanks a lot in advance.
Solved! Go to Solution.
@kpavan999
You can also access each report page by its own URL. When you click on each report page in the service, you will see the portion after the ReportSection is different like the example below. Click on the desired page and grab the URL.
/ReportSection677860c1a158e04191d8
It can also be like /ReportSection2
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@kpavan999
I believe you are referring to "Filter a report using query string parameters in the URL".
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
Regarding your question, you can pass text values to filter a Table > Column. If you can explain the business problem you are trying to solve, it will give more context to your question.
I am also sharing a useful video for your reference: https://www.youtube.com/watch?v=2FhaWkb9YcU
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Lets say in my target report, I have 5 tabs. In the URL, can I pass the tab name where it has to land when the hit the URL.
For Eg
My report has TabA, TabB, TabC, TabD, TabE
I want to directly open TabC using the URL
something like this
app.powerbi.com/........./sheetname eq 'TabC'
@kpavan999
By default Power BI report will default to the page which was showing at the time of publishing to the service but you want to share a report link with a specific page/sheet, you need to add the following
syntax at the end, ReportSection is the default you can change it to ReportSection1, ReportSection2, and so on:
&pageName=ReportSection1
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@kpavan999
You can also access each report page by its own URL. When you click on each report page in the service, you will see the portion after the ReportSection is different like the example below. Click on the desired page and grab the URL.
/ReportSection677860c1a158e04191d8
It can also be like /ReportSection2
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Thats a good idea, thank you
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |