Forum Discussion

bathyphen's avatar
bathyphen
Frequent Visitor
3 years ago
Solved

Filtering via the URL

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:_Customer_Data/TLA_No 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:_x0020Customer_x0020Data/TLA_x0020No eq '0080000807'

 

Any help would be greatly recieved as it's driving me mad šŸ™‚

 

Kind Regards

 

Carly

2 Replies