Hi, do you know if it is possible to somehow create URL to filter report where variable CONTAINS a value? The operators 'eq' or 'in' are used only for exact values. In Power BI itself, it is possible to use advanced filters to filter on the CONTAIN value. A workaround could be to set the value of a variable via URL and have the report filtered based on this. Do you know if it is possible to set variable values in the report via URL?
Thanks @MITutorials this video its very usefull !!! I have one question: I do all the steps of modifying the URL using "?filter=table/variable eq value" but the report doesnt get the filter. Ive tried with several reports, but the URL filter is not working in any of them. I thinks its a configuration problem but I dont know how to solve it, Do you have any idea?
Ok, after many hours I finally got this to work: (url)&filter=Table1%2FCategory%20eq%20%27Snacks%27 Not sure why but the / after Table1 was changed to %2F automatically. I'm trying to get this working when embedding in Sharepoint, but this code does not work there- any ideas please?? Thanks for the solution though!!!!
Hey MITutorial, I really appreciate the explanation! I'm planning to implement a single Power BI report for multiple clients and embed it into our website. Would you recommend using a single dataset with a customer ID to differentiate the clients, or is it better to use separate datasets for each client and bind them dynamically? Which approach would provide better performance and security when embedding the report, and how would I proceed with implementing that?
How do we achieve this if I have posted my power bi url in the web application which has the same slicers as power bi. How do I pass the parameters from web application to the power bi url
Thanks for the tutorial! The "in" portion was what I needed.
Hi, do you know if it is possible to somehow create URL to filter report where variable CONTAINS a value? The operators 'eq' or 'in' are used only for exact values.
In Power BI itself, it is possible to use advanced filters to filter on the CONTAIN value. A workaround could be to set the value of a variable via URL and have the report filtered based on this.
Do you know if it is possible to set variable values in the report via URL?
Thanks @MITutorials this video its very usefull !!!
I have one question:
I do all the steps of modifying the URL using "?filter=table/variable eq value" but the report doesnt get the filter. Ive tried with several reports, but the URL filter is not working in any of them. I thinks its a configuration problem but I dont know how to solve it, Do you have any idea?
Same issue
my url reverts to the normal one
Ok, after many hours I finally got this to work: (url)&filter=Table1%2FCategory%20eq%20%27Snacks%27 Not sure why but the / after Table1 was changed to %2F automatically. I'm trying to get this working when embedding in Sharepoint, but this code does not work there- any ideas please?? Thanks for the solution though!!!!
Hey MITutorial, I really appreciate the explanation!
I'm planning to implement a single Power BI report for multiple clients and embed it into our website. Would you recommend using a single dataset with a customer ID to differentiate the clients, or is it better to use separate datasets for each client and bind them dynamically? Which approach would provide better performance and security when embedding the report, and how would I proceed with implementing that?
How do we achieve this if I have posted my power bi url in the web application which has the same slicers as power bi. How do I pass the parameters from web application to the power bi url
Did you try the same logic explained in this video !?
very useful
how we can pass parameters in public url of power bi dashboard and embed with our own application
You need to know the table and column names to filter. Once you have created the URL use the same to embed the report,
@@MITutorials my filters are ignored when I try to do this!
@@elnazbashir2055 mine too
This is great.
Thinking out loud haven’t tried it myself. What would happen if no slicer selection is made.? Will the url work?
Yes it will work!
If no selection is made or if the slicer has “show all” value how will the measure be evaluated?
Wow your fabulous
Thanks alot dood