Is it possible to dynamically create a table visual based on URL parameters?

[Anonymous]

I'd like to have a table visual in Power-Bi which is dynamic in nature based on the URL parameters. Like for example, if in the URL I pass the values as "Country" and "State" , a table should be generated with only those two columns.

[v-xicai · Accepted solution]

Hi @Anonymous ,

Currently, the URL filter parameter can to pre-filter the report , which will only filter data on row values instead of number of columns. For example , the URL like codes below will filter data 'Table1'[Country] = 'USA' , instead of filtering data to remain the only column Country in the whole report.

app.powerbi.com/groups/me/apps/app-id/reports/report-id/ReportSection?filter=Table1/Country eq 'USA'

That is to say it is not supported to implement in Power BI currently. While your demand is a good idea, and you can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , power Bi service you can pass like

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