Discrepancies between PowerBI Desktop and PowerBI service when made change to load queries.

[powerbiuser1]

I made some changes in the Query editor in PowerBI desktop. When published to service and after waiting for all data to be refreshed, the counts in the chart dont match.

I am working with data stored in Azure blobs. Every day some data is added to Azure Blob.

PowerBI service is setup with auto refresh.

My chart is showing a Measure = COUNTROWS(tablename).

I checked few dates, the counts in PowerBi desktop seem to be accurate. However, the data in PowerBI service is also greater than expected.

When the data is loaded from AzureBlob, I am doing a bunch of operations on it in the Query Editor. Like changing data types for certain columns to date, extracting date value, removing duplicates using 1 key column, adding an index, sorting the data on 2 columns, renaming columns etc.

Can it happen that the load query runs differently on desktop vs service? Or the specific COUNTROWS measure is executed differently?

[v-caliao-msft]

@powerbiuser1,

I don't think that the load query runs differently on desktop vs service. And I have tested the issue in my local environment, COUNTROWS function return the same result in Power BI desktop and Power BI services.  In your scenarion, could you share your PBIX file, so that I can test it on my local environment and make further analysis.

Regards,

Charlie Liao