Error displayed on tiles on streaming dataset

[Nuzhi]

Hi,

I am getting the following error when I integrate a streaming dataset with my PowerBI Dashboard. I am using Azure Stream Analytics to stream the data. Quite a few of the tiles I created which use the streaming data work, while another a tile gives an error similar to the one displayed here. Any fix for this ?

Best Regards,

Nuzhi

[v-haibl-msft]

@Nuzhi

If your Azure Stream Analytics query results in very rapid output to Power BI (for example, once or twice per second), Azure Stream Analytics will being batching those outputs into a single request. This may cause the request size to exceed the streaming tile limit. In that case, streaming tiles will fail to render.

In such cases, the best practice is to slow the rate of data output to Power BI; for example, instead of a maximum value every second, set it to a maximum over 10 seconds.

Best Regards,
Herbert

[Nuzhi]

Hi @v-haibl-msft

How do I slow the rate of data output. Is it from the Azure Stream Analytics end or is there any possibility of doing it from within Power BI ?

Best Regards,

Nuzhi

[v-haibl-msft]

@Nuzhi

We can use a Tumbling window or Hopping window to ensure that data push is at most one push per second, and that your query lands within the throughput requirements.

Please refer to https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-power-bi-dashboard#learn-ab.... A sample is given there.

Best Regards,
Herbert