cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

Guy I spoke to in support reckons by this Friday (29th) they will solve the speed issues.

Highlighted
Advocate I
Advocate I

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

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!

Highlighted
Advocate II
Advocate II

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

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.

Highlighted
Helper II
Helper II

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

Agree with this.  Did the same steps and my 18 minute refresh takes less than 3 mins now.  

Highlighted
Advocate II
Advocate II

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

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.

Highlighted
Regular Visitor

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

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?

Highlighted
Advocate I
Advocate I

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

@mgreezMSFT tells me that they have resolved the issue. Are you still seeing date type as unclassifed? My case has been resloved. 

Highlighted
Advocate II
Advocate II

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

@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

Highlighted

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

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.

 

😞

 

Scott

Highlighted

Re: Just started this week - DATAFLOW table does not show up in Power BI desktop

p.s. opening a ticket too, will post updates as I get them.

 

Thanks,

Scott

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.