Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
A table query in PowerBI Desktop displays different values in the PowerBI service. A query in PowerBI Desktop displays this information.
The same query in the PowerBI service shows these results:
The True or False values correspond to PowerBI logical data types, but the "YES" and "NO" values are text-type values that I calculate with formulas in Power Query, however, these values are also changed when querying the PowerBI service.
Thank you for your support.
Is it possible that the PowerBI service is more (or less) up to date? Try refreshing both datasets and then comparing the results.
Thanks for the reply. Indeed I update the data in Power BI desktop and immediately in the PowerBI service, and all the other tables update well, but precisely this one that has logical values do not update well. This is happening only since last week and although I changed the queries so that they did not have logical fields and use text fields with the values "YES" and "NO", the situation still occurs.
In my practice, this is part of the box is the one that is generated from Power BI Desktop for the performance control of a commercial computer
However, when publishing to the PowerBI.com service in the first instance it appears the same:
But a couple of minutes later I refresh the information and it has already changed.
Thank you very much for the support.
Hi @Syndicate_Admin,
May I know have you found a solution to this issue? Many thanks.
Best regards,
Esther