cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nuzhi Frequent Visitor
Frequent Visitor

Error displayed on tiles on streaming dataset

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 ?

 

PowerBI error.PNG

 

Best Regards,

Nuzhi

3 REPLIES 3
Microsoft v-haibl-msft
Microsoft

Re: Error displayed on tiles on streaming dataset

@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.

 

Error displayed on tiles on streaming dataset_1.jpg

 

Best Regards,
Herbert

Nuzhi Frequent Visitor
Frequent Visitor

Re: Error displayed on tiles on streaming dataset

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

Microsoft v-haibl-msft
Microsoft

Re: Error displayed on tiles on streaming dataset

@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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)