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
