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