cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tharding Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

All of the other entities that work are based on existing tables. It's only the date only data type that seems to be causing the problem.

ColinR Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

I use an integer as my key that looks like a date   ie 20191119 (today), it may be too late for you to make this change

tharding Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

Unfortunately this comes from a long-standing data warehouse. I don't get why the date column is causing this issue though.

Highlighted
Streamline Occasional Visitor
Occasional Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

It does indeed seem to be an issue with the data type 'Date'. 

Since this week, 16 of the 19 entities no longer appear when connecting to the dataflow from Power BI Desktop. Thanks to this topic, I found out that these entities all contain columns with dates. I have changed the data type of these columns to 'Datetime' and now it works again. 

philippfrenzel Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

Yes agree, the change from date to datetime solved it for me too, still it is a work around and cost me a lot of time to change it in all tables 😕 Anyway still happy with the progress in Power BI so I'm willing to ignore this bug. 😉

tharding Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

Moderator in Issues forum reports thatt the ETA for a fix for this is the end of this week.

philippfrenzel Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

new ETA? still not working 😉

tharding Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

So I noticed...

tharding Frequent Visitor
Frequent Visitor

Re: Dataflow - Entities from a specific server do not show up in Desktop

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,337)