Stream Analytics with power BI Output

PBILover — Mon, 09 Sep 2019 16:01:33 GMT

Hi Everyone,
I have created a stream analytics job with power BI output,in which i am pulling data from two sources:one is from event hub and other is a reference input data from sql. In the main query of this job, i have created several power Bi outputs.

In Power BI side i have created one live dashboard in which i am getting data from these outputs.(I have tested the query from stream analytics side by giving a sample inputs and all output results are showing correct values)
But in a dashboard side i am facing a data discrepancy.
For example : I have a tile in a dashboard which displays total event lets say 50 and then i have another tile which displays total by Client which will also shows total count of 50.
But in third tile if i am displaying data by client wise communication type total then i am facing a data discrepancy .
(for example : In a second tile if client no 1234 have total events 30 then in third tile total by all communication type will not be 30 for client no 1234 . Total distribution will be any random number)
I have observed that if i am grouping on more than 1 column (here in third tile client and Comm type) then i am facing the data discrepancy issue.
Is anyone facing same issue or can anybody please guide me on this?

Thanks

Namita

topic Stream Analytics with power BI Output in Developer

Stream Analytics with power BI Output