Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi there,
I have a problem with Dataflow that Transformation steps is being evaluated differently between "Power Query Editor" mode showing in Editing Dataflow vs. result come out from PowerBI services.
(I have also tried to copy all steps and evaluate in PowerBi Desktop, I got 123 rows too)
(in Data tab)
(and in Power Query Editor mode)
There was nothing special on that 3 rows, they are with normal data like other rows. I also making sure there is no simple mistake here (no filtering, no cross reference).
Anyone has experienced this ? What else can I try to resolve this issue ?
Many thanks in advance!
Any of your data depending on timezones?
Hi Ibendlin, No, data source is a static excel files in SharePoint.
let me ask differently - any datetime fields ?
Yes, there is a date time column in the Excel file (as data column, not a calculated one). Any hints?
Thanks!
- the power bi service runs on UTC
- you are looking at the data based on the browser's user's timezone.
- you have a relative date filter somewhere
-> some data is cut off.
Thanks for suggestions, but I'm very sure it's not the case.
As I mentioned earlier there is no filter being applied. The date/time column is actually showing when the file uploaded to SharePoint, so actually only 2 different time/date values for those 123 rows.
I don't remember read somewhere saying interpretation engines are difference in Editor mode vs in Service background mode ? Could this be the case ?
That could be the case if you were not using a dataflow. For those I would have to assume that the mashup engine matches the ones in the service.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.