Prosperi 365 - Filtering a Microsoft Power BI Report directly from a URL
Вставка
- Опубліковано 21 сер 2024
- This video explains how to filter your Power BI report directly from a URL so anytime you embed your report in a website, it will show the specific content that you need.
Prosperi 365 is a series of short, informative videos about various Microsoft 365 tools and programs aimed to be under 365 seconds (although we may go a little over to make sure you get the best info). Feel free to share any new topic suggestions in the comments!
Hi, I have two reports, In first report lets say I have column c1, on clicking any value of this column in table visual, I need to navigate to the other report and show its related data in second report in any one of page. Kind of cross report drill through but not specifically. How can we achieve this using url query.
Hi sir, I have more than 10 filters ,is there anyway apart from concating two columns using dax and filtering the power bi data because my size of data is too large.
Hi Dharani! Thank you for watching and for your question. Unfortunately the URL is limited to approx. 2000 characters. If you are trying to insert more characters then it is not going to work.
Check this for more information: stackoverflow.com/questions/417142/what-is-the-maximum-length-of-a-url-in-different-browsers
Hi I dont think this works for publish to web (public) do you know how i can do this
Hi,
what is the value that you put after EQ in the ?filter / eq ?????
i try to found the same way to filter in the embed url with this value but it doesnt work
my filter is ?filter = acessos/cod_acesso eq '1' , that need to filter with the code acess number for 1 and apply to my graphics
but doesn't work.
can help me?
Hi Thiago, thanks for watching and for your comment! It seems you are doing it right. Please try replacing the ? symbol with the & symbol. If that does not work, can you share with us the complete URL for us to inspect?
@@rccoudriet Hey Rachael! Thanks for the answer, I try with the & symbol and its works! thank you!!
Hi sir , url parameters are not working i try in lot of reports examples on reports
Hi Satya! Thank you for reaching out and we are sorry to hear that you are having this issue. Can you please send us an email at sales@prosperiglobal.com, giving us more details and screenshots and we will be happy to help you out! :)
working for url public published??
can i make the url to auto authenticate for another users see the report? Without the way to login an account if the user dont login it
Thiago, unfortunately we don't think this is possible. So sorry!
@@rccoudriet Hey Rachael, no problem! I think it need some automation hahahah i need to put the Microsoft my administrator credentials automatically when the user click the button of the embedded report when appear to put the login and password