Forum Discussion

Priyanka2's avatar
Priyanka2
New Member
8 years ago
Solved

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...
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    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

prateekraina's avatar
prateekraina
Memorable Member
8 years ago

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's avatar
    Priyanka2
    New Member
    8 years ago

    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's avatar
      prateekraina
      Memorable Member
      8 years ago

      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's avatar
        Priyanka2
        New Member
        8 years ago

        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