Forum Discussion
Power bi Rest APi GET request
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 .
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.
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.
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.
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.