Filtering via the URL

[bathyphen]

Hi,

I have been trying for some time to pass some parameters into my URL to automatically filter my PBI Report (which has multiple tabs) and I just cannot get it to work. I have read the document online & tried to follow them with no success.

My initial table names & column names had spaces in but I have changed them now (as a test) but I still can't get them to work.

The link I'm using without spaces is:

Table Name = Master:_Customer_Data

Column Name = TLA_No

https://app.powerbi.com/groups/me/reports/8804354f-5d0f-475f-ac16-e7e3f8f59e03?filter=MASTER:_Custom... eq '0080000807'

It just loads the report with no filters altogther (just as it is saved)

An option with spaces was:

Table Name = Master: Customer Data

Column Name = TLA No

https://app.powerbi.com/groups/me/reports/8804354f-5d0f-475f-ac16-e7e3f8f59e03?filter=MASTER:_x0020C... eq '0080000807'

Any help would be greatly recieved as it's driving me mad 🙂

Kind Regards

Carly

[lbendlin · Accepted solution]

colon :  is not an accepted delimiter between table and column. Use a forward slash / .   NO SPACES!!!

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

[bathyphen]

Thank you for your response.

I changed the names of my table & column to have no spaces & it finally worked. Completely forgot about the colon that might have been an issue. 🤦‍♀️