filter BI report through .net application

[Priyanka2]

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.

[prateekraina]

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

[Priyanka2]

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

[prateekraina]

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

[Priyanka2]

Hi @prateekraina,

Thanks for the reply.

I visited the link provided by you and followed the steps specified there.

However, in Azure Active Directory App Registrations when a go for "Select an API", i'm not getting option of "Power BI Service".

The only options available to me are : Windows Azure Active Directory,Microsoft Graph,Windows Azure Service Management API,Office 365 Management APIs

Why i'm not getting Power BI service option?

Is it because i'm using Power BI Desktop and Pro free trail version?

Thanks

Priyanka Prajapati

[prateekraina · Accepted solution]

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