Issue with Live streaming dataset in Power BI

[GovindPrajapat]

in power bi i have a live streaming data set from stream analytics. The table has only 100 records but when i count records using a measure or direct show count in a card, It shows 489 count. What is the issue and how can i resolve this issue? Operations On Live Streaming Data 

[v-yohua-msft]

Hi, @GovindPrajapat 

Perhaps you can use Visual Studio to calculate how many records you have. You can also create an Index for it.

First, open visual studio and create a new project.

Select AS Tabular project

Then Import from data source, select data source

Select one table you want, you can also use the power of Power Query

Create a measure.

Or you can create a column.

Select Desgin

Process all

When visual studio opens, open Power BI desktop and make the live connection

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.