Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
since i had a lot of questions when i started using the Power BI REST API and writing records from Azure Stream Analytics i think the answers i got might be of interest to anyone running into the same problems i had. After knowing about those limits it was pretty easy for me to handle those accordingly.
I also had a problem of degrading performance over time which was related to the fact that the insert performance degrades the larger the table gets. Therefore rows inserted into Power BI FIFO tables should be less than 1kb to avoid performance issues:
I hope to have saved someone a lot of time debugging when running into the same problems! 🙂
Best
Axel
Hi Axel.
Thanks for this info.
In addition, there is one more critical limitation for Power BI REST API service such as maximum 5 pending POST requests per dataset.
I hope this limitations will be updated soon to enable better performace for pushing data do the dataset in the real-time without any degrading of performance on the pusher side.
For example, in my POC project was neccessery slow down pusher (subscriber) of the Azure Service Bus for slowly reading the topic messages and pushing them to the Power BI Service, otherwise there was a many bad responses (429) from the PBI Service. It supprise me this limitation on the Azure platform and I hope this is just only temporary.
Thanks
Roman
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.