Forum Discussion
Dataflow - Entities from a specific server do not show up in Desktop
I have created 2 dataflows in Power BI service. Each has entities sourced from 2 different SQL Servers. In each case the entities from 1 of the servers does not show up under the dataflow in Power BI...
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.
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. 😉
Moderator in Issues forum reports thatt the ETA for a fix for this is the end of this week.
new ETA? still not working 😉