Published version shows incorrect values

[Anonymous]

Hello!

My dataset works correctly in Power BI Desktop and when I publish to the web workspace everything works fine. However, after the first update on the no service, the dataset has completely wrong values.

Desktop Version:

Published version:

[Anonymous]

I'm using hybrid mode. I think the problem is when I enable this Direct Query option:

[Anonymous]

Changing the setting from parallel to concurrent loading resolved the issue.

[Anonymous]

Hi @Anonymous ,

The Get the latest data in real time with DirectQuery (Premium only) setting enables fetching the latest changes from the selected table at the data source beyond the incremental refresh period by using DirectQuery. All rows with a date/time later than the incremental refresh period are included in a DirectQuery partition and fetched from the data source with every dataset query.

For example, if this setting is enabled, with each refresh operation, the service still overrides the RangeStart and RangeEnd parameters to create a query for rows with a date/time after the refresh period, with the beginning dependent on the current date and time. Rows with a date/time after the current refresh operation time are also included.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

Please check if the problem is caused by an update to the dataset, which normally does not occur.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.