Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Filtering a report using Query Parameter

Submitted by Anonymous on ‎08-08-2022 08:10 AM

 

Hi,

 

As per the above link "Filter a report using query string parameters in the URL - Power BI | Microsoft Docs" i tried to use this link to filter my projects in the report. But it is not working for my dataset and I removed all default filters applied and tried using different datasets with different links in different ways. But still my filter is not getting filtered as per the above link:

 

can you please provide the solution for the above issue.

 

Different Queries I have used to filter the report as per the Project Name given:

 

  1. https://app.powerbi.com/groups/5e680850-f172-4d13-bbbd-cb3ac1830ae4/reports/c29d2bb1-23a3-461f-9661-... eq 'TMHIT_TPA_H1T CVI_PDI QA Check Station'
  2. https://app.powerbi.com/groups/5e680850-f172-4d13-bbbd-cb3ac1830ae4/reports/c29d2bb1-23a3-461f-9661-... eq 'TMHIT_TPA_H1T CVI_PDI QA Check Station'
  3. https://app.powerbi.com/groups/5e680850-f172-4d13-bbbd-cb3ac1830ae4/reports/b61a78b5-9304-437a-b763-... eq '5846ff6c-9cc4-eb11-a8ee-00155d1ca70e'  (Instead of using Project Name used Project ID also in the query.
  4. https://app.powerbi.com/groups/5e680850-f172-4d13-bbbd-cb3ac1830ae4/reports/b61a78b5-9304-437a-b763-... eq '5846ff6c-9cc4-eb11-a8ee-00155d1ca70e' (Used Different Data Set also)
  5. https://app.powerbi.com/groups/5e680850-f172-4d13-bbbd-cb3ac1830ae4/reports/b61a78b5-9304-437a-b763-... eq '5846ff6c-9cc4-eb11-a8ee-00155d1ca70e' (Used Different Data Set also)
  6. https://app.powerbi.com/groups/5e680850-f172-4d13-bbbd-cb3ac1830ae4/reports/b61a78b5-9304-437a-b763-... eq '5846ff6c-9cc4-eb11-a8ee-00155d1ca70e'  (If there is a space in the column Name used this Query).
 
 
 
 

 

Can you please provide me the resolution as soon as possible:

 

Thank You.

Status: Investigating
See more ideas labeled with:
4 Comments (4 New)
Comments
AilsaTaoYe
Regular Visitor
‎08-10-2022 01:08 AM

Hi @Anonymous 

If you use a project name as a screening condition , can the query string filter a report in URL ?

AilsaTaoYe_0-1660118895116.png

 

Anonymous
Not applicable
‎08-10-2022 02:37 AM

Hi @AilsaTaoYe

 

Can you please ellaborated the above comment with my dataset .

 

Thanks,

Anusha

Anonymous
Not applicable
‎08-23-2022 01:29 AM

Hi @Anonymous 

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/683031

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎08-25-2022 03:14 AM

Hi @Anonymous , my issue was already solved opening a support Ticket. 

The team did some modifications on latest August version and now it´s working fine for me 

Best regards , 

Idea Statuses