Forum Discussion

sato89's avatar
sato89
Helper I
7 years ago
Solved

Power BI Server and REST calls by angular app

Hi everyone,

I installed an instance of Power BI Server with some reports on a computer and I can view the reports in embed version inside a web-app by adding the parameter "?rs:embed=true" to the report URL in a iframe. My PBI Server is installed with Evaluation License.

Can I use REST API to get reports from my Power BI Server? Note that my reports are on my Server and not on app.powerbi.com.

Can I get this functionality with an Evaluation for the moment or is the Premium license necessary to call my PBI Server via REST from my angular web-app?

 

Thanks in advance.

Best regard.

 

Salvatore

  • Anonymous's avatar
    Anonymous
    7 years ago

    The simplest of the PBIRS API calls is as shown in the screenshot. 

    Here is the code if you want to invoke the same API call using PowerShell 

     

    $Cred = Get-Credential
    $Url = "http://powerbi.local/Reports/api/v2.0/Me"
    #Invoke-RestMethod -Method 'GET' -Uri $Url -UseDefaultCredentials -OutVariable UserContext
    Invoke-RestMethod -Method 'GET' -Uri $Url -Credential $Cred -OutVariable UserContext
    echo $UserContext

     

     

    Here is the list of PBI RS APIs that you can play with.

     

    Please accept the solution, if you agree.

     

    Cheers,

    Hari T

     

     

  • Anonymous's avatar
    Anonymous
    7 years ago

    You can set your cedentials at the GET request level by choosing the Authorization method as "NTLM Authentication".

     

    This is when you are on windows and using Windows Authentication. You can also set the Domain of your Org. in the advanced properties.

     

    Cheers,

    Hari T

10 Replies

  • Jon-Heide's avatar
    Jon-Heide
    Microsoft Employee

    There is no functional difference between evaluation edition and full enterprise, aside from a timebomb and licensing rules. You can use the evaluation edition for purposes of dev/test and demo's. Running it in any production evironment will require the appropriate SQL enterprise core or PowerBI premium licenses.  

    • sato89's avatar
      sato89
      Helper I

      Thank you for your reply!

      So, how can I obtain the embedded token for my REST calls to PBI Server? I tried to implement a REST call from an Angular app but I didn't know the correct way to get this token.

      My reports are published on a PBI Server instead of PBI Services (app.powerbi.com).

       

      Thank you!

      Best regards.

      • Anonymous's avatar
        Anonymous
        Not applicable

        I haven't tried Angular to make the Rest Api calls but used powershell/postman to make the calls. You can set the security context at the request level or Collection level while making an API call. This worked like a charm for me.

         

        Cheers,

        Hari T