Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Power bi Rest APi GET request

Hi everyone ,

 

Could you please help , i  have  power bi dashboard that is published in my workspace and have created on streaming db , which it has been connected to, Now my requiremnts are i need to embed power bi in to angular website where we need to give get request to call Power bi rest api to generate report name and provide a report link.

 

we tried giving https://api.powerbi.com/v1.0/myorg/reports

 but it gives 401 error , what all i need to check so that it can work.

 

 

 

"Power BI Old Version"
"Power BI Report Server "

10 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?  What streaming db?  Are you using s Streaming Hybrid Dataset?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    lbendlin  so basically my problem statement is 

    Backend Processing (Saving and Calling Power BI API)

    • Query Execution and Data Library Creation:
      • The user inputs a query in the Angular portal.
      • The backend executes the query and stores the results in a JSON file, which is then sent to Power BI through a push endpoint API.
      • The JSON file gets stored in the streaming dataset within the Power BI workspace, where the structure matches the data in the JSON file. Angular Frontend (Displaying Data and Embedding Power BI Reports)- TO EMBED  THE LINK WE need to call the power bi rest api and we have wtitten this calling GET https://api.powerbi.com/v1.0/myorg/reports but when we are trying from postman it gives error 401 .
    • lbendlin's avatar
      lbendlin
      Super User
      1 year ago

      You pushed the data into a streaming dataset.  That's just a dataset.  A report is not automatically generated. You need to do that yourself, most likely manually.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Now this 401 issue is resolves , could you please guide us for the process , how we can generate reports on the fly for different request from the angular website of opening different library data and passing it to Json and push it to backend API that is capable of serving the required data in report format based on the user's request. .

        • Handling Multiple Requests: If there are multiple users requesting reports simultaneously, How it can handle  n concurrent requests efficiently and how we show multiple reports for each library.