Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kpavan999
Frequent Visitor

Passing Sheet name in URL

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.

 

1 ACCEPTED 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  





Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

5 REPLIES 5
Fowmy
Super User
Super User

@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



Did I answer your question? Mark my post as a solution! and hit thumbs up


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

Did I answer your question? Mark my post as a solution! and hit thumbs up


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  





Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thats a good idea, thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.