Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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