Hi Adam, You guys are doing an awesome job. One small correction. You can have spaces in the table and field name which can be replaced by this character _x0020_. Second correction - it can filter on multiple fields by inserting a "and" between the fields This hack works like a charm. Cheers, Hari
You are correct. We updated the video and mentioned those new capabilities. Here is the link: ua-cam.com/video/8ASw-J0PuN8/v-deo.html. Thanks for watching.
When setting a filter via URL, it is worth mentioning that if you have a filter control on the report that is saved with a value selected, then the report will ignore the URL directive: the saved filter will take precedence. For example, a report has a filter called Region with two values: US and EMEA. If you save the report with US selected and try to pass a URL parameter for EMEA (?filter=MyDataset%252FRegion%20eq%20%27EMEA%27), the report will ignore the URL and display NA results. You can save the report with the filter not set to anything and it will work, however the value you pass will be the only value visible in the filter (as if you had a Page-level filter set). In this example, the filter control would show EMEA as the only option--no "NA" option). All of this makes passing parameters in URLs a little quirky because you have to optimize your whole report around it.
Thanks for adding that Hymie! I hadn't actually paid attention to that aspect. I will also make sure that piece gets updated in the official docs as well as a limitation.
Hi All, I have a question on passing multiple values in a parameter , for example in this video explained that Passed one value 'NC' in URL and i would like to add multiple values NC and PA also how to pass multiple values in URL.
I started out with Power BI just a few months ago and it is transforming the way our company shapes data. I'm not an expert, for many years I worked at a user level on the database side, mostly exporting data to Excel and running Pivot Tables, sometimes writing queries, and all of that. I would love to go deeper and learn more about Power BI and was wondering if you offer or recommend any courses. Thanks
Microsoft has a free course on EdX, but I don't know that I would consider that deeper. May be worth a look, though. It is labeled as introductory, though. www.edx.org/course/analyzing-visualizing-data-power-bi-microsoft-dat207x-4 You may want to check out folks like powerpivotpro.com, sqlbi.com or pragmaticworks.com for actual course material. There are different blogs and youtube channels that offer varying array of items, though.
I checked out the EdX and it really seems introductory for me - although sometimes it's a good idea to go back and learn well the basic concepts. But there is a plenty of options on the other three links you sent. :) Thanks a lot!
In that case user can change the URL's query string part to see report with different filter, even though we don't want him to see report with other filter values? anyway to hide query part of string or generate an alias url?
You talk about the tile url is there a way to filter out so i just see one spesefic visual objekt ? like a table or a circel diagram i just the url string?
Hi Adam, Thanks for this tip. There seems to be a limitation to this if not *all* visualizations on the report section have valid data returned from the filter. I have 4 visuals. When I apply my filter to each of them individually, 3 of them return data and 1 doesn't so when I apply the filter to the report URL, all visuals come back blank. Is that what you'd expect?
Can we use this with the embedded report on a company site? We want to restrict location when a user sign in to the website and the location is defined in the URL. Would having the URL in this template allow the filter to work?
I love this idea and would love to use within SharePoint Online embedded report. It doesn't seem like this works with embedded reports. Please tell me I'm wrong.
You can, as you can have a unique URL for the page sections. Although This was made before the bookmark features were showed off at Data Insights Summit. Although they aren't released yet. Those will make it a lot easier.
help please, I still can't apply the filter to the visualization, what kind of visualization that automatically connect to URL filter or what should I do to the visual to connect it? it's my second days with power BI
I tried this, it worked! but I used a filter which was already in the filter pane, and I notice that url filter creates another filter in the report filter pane, instead of using the filter which was already in the pane. Any idea how to fix this?
Hey this is for navigation from one report to other. if a link is stored in backend table and shown up on the report as a icon and when clicked it's opening in a new tab. is there any way to supress and open link in same page
Thank you for the above example. It's great. I am trying to call tab2 from tab1 in the same report. tab1 uses 15 KPI visual to have an executive summary. I am looking for onClick event on each so it passes 2 parameters to call tab2. I am using your example above. It helps partially. In my tab2 I have slicers. It seems the value is passed correctly but slicer still shows default value. am I missing something?
Hey great video I did get this working when it's working when I pasted that query string into a Web browser however it's not working when I try to pull it into a poweramp for some reason it's really odd and I've seen it work for other people and videos on poweramps but for some reason mind isn't doing a filter
Hi Adam, I’m using that syntax to filter my report, but my report isn’t filtering. Instead it’s bring the filter to the screen with a warning sign and still displaying all values. My data is all text and there is no space in between. My data is in SSAS and it’s all working on premises. Is that works on premises? Is there any thing I can change in the PBIRS set up to make it work? Thanks
This is really an interesting functionally. Of course it would be awesome if more parameter could be sent without having to concatenate the field. Additionally, it would be even better if it would accept the table and/or column name to have space in it (I use SSAS as data source). Anyway, I've tested this on SSRS vNext and I wasnt able to send filters via URL. Do you know if this is on the radar?
It is not available in the current technical preview. I haven't heard if this specific functionality will be there in the future. I'll keep my eye out though and report out if it does end up in there.
Hi Patrik, its not working any more. Some changes in recent PBI version could be seen. In Edge browser in the browser it shows ctid now whereas in other browsers I don't. earlier ctid was not there. filter column used to get added in the filter pane and data was filtered, which is not the case presently. Please help urgently.
@@GuyInACube Hi! Do you know if theres a way of doing it now? I need to filter my reports based on who is logged in on my website and the report is showing on an , is there any way of doing that?
What if my value which I needed to filter contains a '+' . How can I parse them so it works in the URL? Currently its parsed as %20 which is the same as blank spaces
Hi Adam, I have an SSRS report which comprises of a button, upon the click of a button the user is redirected to another report, the first report passes at least 5 parameters into the second report. I am now trying to migrate the report into Power BI and fix the button function as the "Go to report" option is unavailable in Power BI. Could you please help how can I pass those multiple parameters into the second report using the "Go to URL" option?
I suppose you technically could depending on how you wrote the value being passed into the filter. If it is originating from a DAX statement, you would have to code it that way based on the user. If you were embedding the report, you would have much more control of the filters by way of the JavaScript API. I wouldn't use what you are suggesting as a security measure though as they can always just go directly to app.powerbi.com and see the data.
heya ! This is great info, however I am unable to add a custom column that contains url which I am building using Custom Column Formula. It keeps giving me an error - "You cannot apply & and to type Text and Number." How should I fix this ?
Technically yes, but you are the one that has to handle the query string parsing within your app where the embedding is occurring. If you are using something like the SPO web part, it wouldn't do anything with the query string parameters.
This is not a "Pro" item. Typically I have found that if it isn't working, you are probably missing one of the requirements - either missing the ' around the value, or the table/field names aren't cased correctly based on how they are in the model itself. Maybe double check that?
Doesn't work for me as soon as I add ?filter=Table/Field eq 'Value' (same name as Dataset) it does not work, it throws a "Content not available " message and in developer mode (F12) it shows this - DevTools failed to parse SourceMap: app.powerbi.com//scripts/interact.min.js.map
Hi Everybody. I Need to embed a report in an I-frame using public access publishing. Any thoughts on how I can use the URL in which the i-frame is published as a parameter to either filter my dataflow or to use it as part of my power-query in my data source?
Hi Adam, Your videos are very useful and I learnt a lot. I have a problem that I want to apply filter on a particular page whereas I have 10 pages and want to share with someone. Please help me in this respect. Regards, Jamal Qamar
Unfortunately, the URL filtering affects the dataset itself which in turn affects the entire report, not just a single page. If that particular table, and associated relationships, were unique to that page only, that is a way to kind of hack it. You could do that using calculated tables and make copies of the data. Kind of a pain, but it is one way to do it.
Very frustrated with this functionality. While this works in the Power BI Service it does not work through the IOS app. The Power BI program has not kept these two environments in sync for this functionality.
Yes this currently only works with the web browser version. I'm curious how you would expect this to work with the iOS app as there is not an URL available.
Thanks for the info! I didn't try this with content packs. That kinda makes sense as you can't edit the dashboard and it is read only. Probably if you personalize it?
Hi Adam, You guys are doing an awesome job.
One small correction. You can have spaces in the table and field name which can be replaced by this character _x0020_.
Second correction - it can filter on multiple fields by inserting a "and" between the fields
This hack works like a charm.
Cheers,
Hari
You are correct. We updated the video and mentioned those new capabilities. Here is the link: ua-cam.com/video/8ASw-J0PuN8/v-deo.html. Thanks for watching.
When setting a filter via URL, it is worth mentioning that if you have a filter control on the report that is saved with a value selected, then the report will ignore the URL directive: the saved filter will take precedence. For example, a report has a filter called Region with two values: US and EMEA. If you save the report with US selected and try to pass a URL parameter for EMEA (?filter=MyDataset%252FRegion%20eq%20%27EMEA%27), the report will ignore the URL and display NA results. You can save the report with the filter not set to anything and it will work, however the value you pass will be the only value visible in the filter (as if you had a Page-level filter set). In this example, the filter control would show EMEA as the only option--no "NA" option). All of this makes passing parameters in URLs a little quirky because you have to optimize your whole report around it.
Thanks for adding that Hymie! I hadn't actually paid attention to that aspect. I will also make sure that piece gets updated in the official docs as well as a limitation.
Thank you so much. You describe things more clearly. Amazing 🙂
Hi All, I have a question on passing multiple values in a parameter , for example in this video explained that Passed one value 'NC' in URL and i would like to add multiple values NC and PA also
how to pass multiple values in URL.
Excellent. Thanks for the clear explanation. Got this working.
Glad to hear that!
I started out with Power BI just a few months ago and it is transforming the way our company shapes data. I'm not an expert, for many years I worked at a user level on the database side, mostly exporting data to Excel and running Pivot Tables, sometimes writing queries, and all of that.
I would love to go deeper and learn more about Power BI and was wondering if you offer or recommend any courses.
Thanks
Microsoft has a free course on EdX, but I don't know that I would consider that deeper. May be worth a look, though. It is labeled as introductory, though. www.edx.org/course/analyzing-visualizing-data-power-bi-microsoft-dat207x-4
You may want to check out folks like powerpivotpro.com, sqlbi.com or pragmaticworks.com for actual course material. There are different blogs and youtube channels that offer varying array of items, though.
I checked out the EdX and it really seems introductory for me - although sometimes it's a good idea to go back and learn well the basic concepts.
But there is a plenty of options on the other three links you sent. :)
Thanks a lot!
Yeah I was worried about that. I do agree sometimes it is good to get back to basics. Glad the other links were of help.
Hi Gabriel - did you end up looking into any of the content listed above? If so, which was most useful to you?
Hi, this functionnality is available for on-premise version ?
Thank you
4:17 Awesome suggestion! I am going to implement this right away! Thanks a lot!
Awesome! Glad it helped out.
Thank you! I needed to do this and it gave me exactly what I needed. 🥰 Nice!
Lo pudiste hacer?
used this before but it does not work with in a content pack that's shared as the I'd of the report changes...still very useful in some cases.
Interesting. Maybe because the Report GUID changes? I'll have to play with that a little more. Hadn't tried it with content pack reports.
Great info, thanks!
Most welcome Bill! Thanks for watching!
Nice video, Thanks for sharing.
I have a question on parameters: how do I delete/remove the parameter that I linked to the field?
Thank you!
This one works great on service. But do you know how to make it possible in the app? Or will it be possible through the app (mobile)?
Do we have any alternative for filtering power BI Reports for a web published URL ?
I'd like to know it too. Did you get any news?
Does this feature works in Power BI Server Report? thanks
Not currently. It is being worked on though. Don't have a timeline.
In that case user can change the URL's query string part to see report with different filter, even though we don't want him to see report with other filter values? anyway to hide query part of string or generate an alias url?
You talk about the tile url
is there a way to filter out so i just see one spesefic visual objekt ? like a table or a circel diagram i just the url string?
Hi Adam, Thanks for this tip. There seems to be a limitation to this if not *all* visualizations on the report section have valid data returned from the filter. I have 4 visuals. When I apply my filter to each of them individually, 3 of them return data and 1 doesn't so when I apply the filter to the report URL, all visuals come back blank. Is that what you'd expect?
hmmm haven't run into that myself. I will have to take a look at that behavior.
Can we use this with the embedded report on a company site? We want to restrict location when a user sign in to the website and the location is defined in the URL.
Would having the URL in this template allow the filter to work?
I love this idea and would love to use within SharePoint Online embedded report. It doesn't seem like this works with embedded reports. Please tell me I'm wrong.
Can we show the filter parameter has been sent in url link in a text visual in the power bi report ?
Awesome post... I'm wondering if I can use this technique to link to another page in the same report to show detail records. Thoughts?
You can, as you can have a unique URL for the page sections. Although This was made before the bookmark features were showed off at Data Insights Summit. Although they aren't released yet. Those will make it a lot easier.
help please,
I still can't apply the filter to the visualization, what kind of visualization that automatically connect to URL filter or what should I do to the visual to connect it? it's my second days with power BI
I tried this, it worked! but I used a filter which was already in the filter pane, and I notice that url filter creates another filter in the report filter pane, instead of using the filter which was already in the pane. Any idea how to fix this?
Is there any workaround for 'Field name can't have spaces' ?
Hey this is for navigation from one report to other. if a link is stored in backend table and shown up on the report as a icon and when clicked it's opening in a new tab. is there any way to supress and open link in same page
Thank you for the above example. It's great.
I am trying to call tab2 from tab1 in the same report. tab1 uses 15 KPI visual to have an executive summary. I am looking for onClick event on each so it passes 2 parameters to call tab2.
I am using your example above. It helps partially. In my tab2 I have slicers. It seems the value is passed correctly but slicer still shows default value. am I missing something?
Hi can we url filter from power bi service to power bi report server on premise? Please advise
Is it possible to pass the data source (API url) as a query string parameter?
I'm having trouble doing this in a Group. no problem in my workspace, but won't work on a group, ¿did you resolve this?
But I can't pass a value to a parameter?
Hey great video I did get this working when it's working when I pasted that query string into a Web browser however it's not working when I try to pull it into a poweramp for some reason it's really odd and I've seen it work for other people and videos on poweramps but for some reason mind isn't doing a filter
Thanks for the explanation, but does it work for the embedded report URL ?
This specific approach doesn't work for Embedded. You can use the JavaScript API to set filters though.
This doesn’t seem to work for Public reports. What is the solution ?
Just fyi. You mentioned "+" as concat, but the dax on the screen has the valid "&" instead.
Yeah, I said it wrong. The & is correct :) caught that when I was editing the video.
Is there any way to decode web URL and get only the page name?
Hi Adam, I’m using that syntax to filter my report, but my report isn’t filtering. Instead it’s bring the filter to the screen with a warning sign and still displaying all values. My data is all text and there is no space in between. My data is in SSAS and it’s all working on premises. Is that works on premises? Is there any thing I can change in the PBIRS set up to make it work?
Thanks
You are awesome :)
Thank you Palavai!
This is really an interesting functionally. Of course it would be awesome if more parameter could be sent without having to concatenate the field. Additionally, it would be even better if it would accept the table and/or column name to have space in it (I use SSAS as data source).
Anyway, I've tested this on SSRS vNext and I wasnt able to send filters via URL. Do you know if this is on the radar?
It is not available in the current technical preview. I haven't heard if this specific functionality will be there in the future. I'll keep my eye out though and report out if it does end up in there.
Hi Patrik, its not working any more. Some changes in recent PBI version could be seen. In Edge browser in the browser it shows ctid now whereas in other browsers I don't. earlier ctid was not there. filter column used to get added in the filter pane and data was filtered, which is not the case presently. Please help urgently.
This would be good, if it could with "Publish to web"
Thanks for watching Sten! I don't know that that will ever be an option with Publish to Web.
@@GuyInACube Hi! Do you know if theres a way of doing it now? I need to filter my reports based on who is logged in on my website and the report is showing on an , is there any way of doing that?
@@sachaalter851 Hi Sacha- I had a similar use case, were you able to find any resources for this?
What if my value which I needed to filter contains a '+' . How can I parse them so it works in the URL? Currently its parsed as %20 which is the same as blank spaces
docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters
Hi Adam, I have an SSRS report which comprises of a button, upon the click of a button the user is redirected to another report, the first report passes at least 5 parameters into the second report. I am now trying to migrate the report into Power BI and fix the button function as the "Go to report" option is unavailable in Power BI. Could you please help how can I pass those multiple parameters into the second report using the "Go to URL" option?
Can you pass values based on the user who is viewing the dashboard? Similar to dynamic reporting in SFDC?
I suppose you technically could depending on how you wrote the value being passed into the filter. If it is originating from a DAX statement, you would have to code it that way based on the user. If you were embedding the report, you would have much more control of the filters by way of the JavaScript API. I wouldn't use what you are suggesting as a security measure though as they can always just go directly to app.powerbi.com and see the data.
Have u try to pass dynamic user as value?
heya ! This is great info, however I am unable to add a custom column that contains url which I am building using Custom Column Formula. It keeps giving me an error - "You cannot apply & and to type Text and Number." How should I fix this ?
Convert the number to text - Text.From(). This will allow you to do the concatenation.
What about reports publshed to web?
Hi Assam, this is awesome... does it works for multiple tables as I have got to filter multiple tables.
Even I have to filter two field from 2 tables how to do that?????
Hi , what if our column or table name have space?, how to mention it in URL
Replacing the space with _x0020_ seems to work
Hi, my Power BI redirects me to the Report URL and the result is an unfiltered report
I have same problem. Have you solved that problem? Even if I am filtering my reporot in PBI workspace ther Url is not changing.
Is it posible to use the URL filter in to the url sharing as embedded power bi report ?
Technically yes, but you are the one that has to handle the query string parsing within your app where the embedding is occurring. If you are using something like the SPO web part, it wouldn't do anything with the query string parameters.
Hi Adam. Liked very much this video and i´m trying to use this but its not working. Do I need a pro account to use this feature?
This is not a "Pro" item. Typically I have found that if it isn't working, you are probably missing one of the requirements - either missing the ' around the value, or the table/field names aren't cased correctly based on how they are in the model itself. Maybe double check that?
I do not know what I was doing wrong, but today it works! :-)
Thank you Adam.
:) welcome to the cloud.
Not sure what it was.
Doesn't work for me as soon as I add ?filter=Table/Field eq 'Value' (same name as Dataset) it does not work, it throws a "Content not available " message and in developer mode (F12) it shows this - DevTools failed to parse SourceMap: app.powerbi.com//scripts/interact.min.js.map
Hi Everybody. I Need to embed a report in an I-frame using public access publishing. Any thoughts on how I can use the URL in which the i-frame is published as a parameter to either filter my dataflow or to use it as part of my power-query in my data source?
Consulta, lograste resolverlo?
Hi Adam, Your videos are very useful and I learnt a lot. I have a problem that I want to apply filter on a particular page whereas I have 10 pages and want to share with someone. Please help me in this respect. Regards, Jamal Qamar
Unfortunately, the URL filtering affects the dataset itself which in turn affects the entire report, not just a single page. If that particular table, and associated relationships, were unique to that page only, that is a way to kind of hack it. You could do that using calculated tables and make copies of the data. Kind of a pain, but it is one way to do it.
Really useful tip, thanks. FYI, it appears not to work in the Power BI iOS app, will take you to the correct report but not apply the filter :-(
Yes, that is a current limitation. It doesn't work with the mobile apps.
@@GuyInACube do you happen to know if this has been fixed?
Will it work with web published URL ?
I just tried it and it doesn't appear to work :(
too bad :(
I'd like to know it too. Did you get any news? Thx :)
any updates for this "Will it work with web published URL?"?
Nope ... does not work
does anyone knows how to do this on embed reports links? :(
Very frustrated with this functionality. While this works in the Power BI Service it does not work through the IOS app. The Power BI program has not kept these two environments in sync for this functionality.
Yes this currently only works with the web browser version. I'm curious how you would expect this to work with the iOS app as there is not an URL available.
u can't set a custom url in content packs
Thanks for the info! I didn't try this with content packs. That kinda makes sense as you can't edit the dashboard and it is read only. Probably if you personalize it?
Hi!! How can I do this with a generated link?
What do you mean by generated link? Do you mean a URL created via DAX?
@@GuyInACube Tks, it work with web published URL ?
HI
Whats the point of this