Forum Discussion

ToniHeinrichsIB's avatar
ToniHeinrichsIB
Frequent Visitor
3 years ago
Solved

Publish to web URL filter (replicate POLITICO report)

As asked in other messages in the forum, I want to replicate a functionality in this POLITICO report 

 

https://app.powerbi.com/view?r=eyJrIjoiZTA5N2VkYWQtYmNiMS00YWFmLWEwZWQtOGY4MmExNTlmZjllIiwidCI6ImMyOGQyZTEyLTA5ODgtNGFjZi1iZGJhLTExOTU4MmU4ZDA4ZCIsImMiOjl9&Country=Germany

 

As you can see, it looks like a "Published to web" report, but you can add a Paramter in the URL (which is not supposed to work in this method of publication). How can I do it?

 

I've seen comments in differents posts talking about it. They use Javascript (https://community.powerbi.com/t5/Desktop/URL-Parameters-in-view-mode/m-p/809872) but I'm not sure if I can use this without paying for embedded analytics. In this post (https://community.powerbi.com/t5/Developer/URL-Filter-to-Publish-to-Web-Report/td-p/678444) they suggest that they are using a custom visual, how could I do that?

Finally, here (https://community.powerbi.com/t5/Service/Publish-to-Web-Public-URL-Filtering/m-p/2859685#M177294) they suggest that this is not using a parameter and that they made a page for each country.

 

I'm using a Free license, so I can't use Pro/Premium options, any answers will be apreciated.

 

Thanks for your time

  • lbendlin's avatar
    lbendlin
    3 years ago

    That's what the documentation says, yes. Have not tested it myself yet.

7 Replies

  • Hint:  Throwing the sample URL at a Base64 decoder yields

     

    {"k":"e097edad-bcb1-4aaf-a0ed-8f82a159ff9e","t":"c28d2e12-0988-4acf-bdba-119582e8d08d","c":9}

     

    So you can create your own URLs (including the filters) by reconstructing that Base64 encoded string from your workspace/dataset IDs.

    • ToniHeinrichsIB's avatar
      ToniHeinrichsIB
      Frequent Visitor

      Sorry, lbendlin but I don't understand what you are talking about. I just started with Power BI a few months ago. Do I need any paid licenses to do that?

       

      Thanks

  • I don't think so - you seem to want to publish to Web, right?