I've not had a chance to fully test it, but I think that if you click to "edit" the entities, and then save and refresh, they now appear ok.
Bit of a pain if you have lots of different Dataflows, but it's better than it was!
Thanks I can confirm the same finding/solution as above (Edit entity, Save and Close, Refresh). Not perfect but allows me to proceed with our data now.
Does anyone have an update on whether the DATE fields can be switched back from TEXT to DATE? I believe that was the key issue and workaround on this thread.
I still so no resolution to this problem. I don't know if anyone else is experiencing this, but my queries no longer seem to returning correct results. This started on Nov-12. I think the problem is the merge is not working. But my query refreshes each day, should return the same results and doesn't. I think there a bigger problems here than just the date-to-text problem.
Is anyone else seeing wrong results with their power queries in dataflows?
@ereza Sorry for the late response, just got back from PTO.
I removed all the Dataflow steps to convert Datetime to String and it is working as expected. I'll check back in the morning to confirm the scheduled refreshes work as expected
Resurfacing this issue. We are currently hitting issues where DATE type columns show up with ERROR when trying to consume them in either Power BI desktop, OR as linked entities in another dataflow. Looks like Microsoft has broken something again with date fields.
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.