Forum Discussion

sashokku's avatar
sashokku
Regular Visitor
6 years ago

Automatic user selection on filter in Power BI & auto export the Power BI report as Excel

I have a Power BI report currently in Power BI desktop. The report has a filter for customer name field with 40 different customer names. Is there any way that only one customer is selected automatic...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

sashokku I thought there was a way to pass filters via the report URL and if that is the case, maybe you could do it via the REST API?

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

sashokku - Here is how to pass query string parameters to your report:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

 

However, unfortunately the REST API cannot be used for this from what I can see. The REST API commands for reports mainly only take the report id as a parameter, not a URL to the report. Thus, it does not look like you would be able to do that via the REST API's.

 

I also do not see a way to set your RLS role in the REST API's.