Forum Discussion
filter BI report through .net application
Hi Everyone,
I have created a report in Power BI and published it to Web and got the URL also.
I'm using this URL in my .net web application.
Also,i'm passing a filter in the URL but the filter is not getting applied.
"&filter=V_RawData~2FBU%20eq%20%27Cardio%27"
Based on the filter the BU list should have only Cardio.
The filter is not getting applied.
Please can anyone help me with this.
Why the filter is not getting applied?
Thanks in advance.
Hi Priyanka2,
I would suggest you to register your webapp using this portal.
Make sure you are signing in with the same credentials you use for Power BI.
After registerting the webapp on this portal, note down the Client ID, it will be later used and resume your step of applying permission from the previous link where you were stuck.
Prateek Raina
5 Replies
Hi Priyanka2,
You cannot filter a report via URL which has been published to web.
In order to filter reports like this, you need to embed the reports using Power BI Embedded App Owns Data approach by properly fetching a token and then using Embed Token to embed the report in Iframe.
Here is the link which will help.
Prateek Raina
Hi prateekraina,
Thanks for your quick help.
I will go through the link and try to embed the reports.
Just had a query, do i need to purchase Power B I Desktop for this embedding or this can be done on free version?
Thanks
Priyanka Prajapati
Hi Priyanka2,
Power BI Desktop is a free tool to create and publish reports.
However, you need a Power BI Pro License to embed reports into applications which costs ~11$/month including taxes.
When you are ready for Production with huge amount of end-users then you should probably purchase Power BI Embedded.
If you are just trying out at small scale then 1 Power BI Pro License is enough to get started.
Prateek Raina
