topic Power bi Rest APi GET request in Report Server

Power bi Rest APi GET request

Anonymous — Tue, 28 Jan 2025 15:59:24 GMT

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.

Re: Power bi Rest APi GET request

lbendlin — Tue, 28 Jan 2025 17:30:27 GMT

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?

Re: Power bi Rest APi GET request

Anonymous — Wed, 29 Jan 2025 06:09:30 GMT

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 .

Re: Power bi Rest APi GET request

lbendlin — Wed, 29 Jan 2025 23:18:29 GMT

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.

Re: Power bi Rest APi GET request

Anonymous — Thu, 30 Jan 2025 07:00:28 GMT

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.

Re: Power bi Rest APi GET request

lbendlin — Thu, 30 Jan 2025 12:22:50 GMT

Why do you push the data into a single streaming dataset if you then want to use separate reports? I would recommend you render the received data directly in your angular framework.

Re: Power bi Rest APi GET request

Anonymous — Thu, 30 Jan 2025 12:33:20 GMT

Any suggestions , how can we implement that .

we were using a streaming database as a solution because directly connecting to the main database is complicated—specifically, connecting hundreds of tables for a single request. As a result, we thought that using the streaming database would be a simpler approach.

The Angular team has been temporarily storing the user-requested data in JSON format. Our plan is to use this JSON data and push it to the streaming database via the push API. Once the data is there, we would connect the Power BI report to the streaming database for reporting purposes. as there could be multiple request at one time from diffrent user and how streaming db will handle that

If you have any suggestions for a better approach or improvements to our current solution, we would appreciate your input.

Re: Power bi Rest APi GET request

lbendlin — Fri, 31 Jan 2025 01:28:52 GMT

As a result, we thought that using the streaming database would be a simpler approach.

yeah, no. You may want to reconsider that. Streaming datasets have a very different purpose.

You are connecting to the main database anyway for each of the individual queries. Consume the results directly for rendering in your angular framework app. Cut out the Power BI middleman.

Re: Power bi Rest APi GET request

Anonymous — Fri, 31 Jan 2025 07:05:14 GMT

The Angular team is temporarily storing user-requested data in JSON format, and o is to push this data to the streaming database via the push API. there is no way we are directly connected to db. Once the data is available in the streaming database, we’ll connect Power BI to generate the reports on the fly. they want to rewrite json for every next query.

If you have any suggestions for improving this approach or alternatives we should consider, we’d appreciate your input.

Re: Power bi Rest APi GET request

lbendlin — Fri, 31 Jan 2025 12:11:32 GMT

My recommendation is to take Power BI out of the equation completely. It provides no value add.

Re: Power bi Rest APi GET request

Anonymous — Fri, 31 Jan 2025 14:52:33 GMT

thats not possible at this stage as we have alraedy billed client..