Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Desktop (the entities from the other server are ok).
The entities refresh OK in the service, and there are no errors that I can see in the refresh history.
The server connection is set up in the gateway.
Any suggestions about where to look would be appreciated. I figure there has to be a setting somewhere I am missing, but I set up all of the entities in the exact same way.
Thanks
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 😉
So I noticed...
I created a new table as "=mysourcetable". It refreshed in the Power query succesfully. however when i saved the dataflow there was no error, but the new entity did not appear. Is this likely the same issue the new stuff isnt saving, and no error being displayed
I can add new entities from the same server, and even the same database that work fine. It appears to be just one table.
We have another database on the same server with an exact copy of the same table (it's a calendar table) and the same issue occurs - seems fine in the dataflow but does not appear as an entity in desktop.
try removing columns incrementally until it loads may be a data type issue ?
You are on to something.
The entity will not load if the key column, which is of type DATE, is included. Remove that column and it appears in desktop. All other date fields in the table are of type datetime. If i change one of those to type date only, then the entity no longer appears.
So there is something caused by the presence of a date only column. This has to be a bug right? My calendar table is not of much use without a date key.
Nice to know your on track, question i have, is why a new table that equals existing table does not appear, does it need bi premium to work ?
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.
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
Unfortunately this comes from a long-standing data warehouse. I don't get why the date column is causing this issue though.
having the same issues. Can't access entities from other dataflows or from PBI desktop. Problem is on Pro and Premium. However, in my case it has nothing to do with the server... I can access other entities from the same server. Furthermore, so far the problem is happening with entities from Dynamics 365 CDM and excel file; in both cases I have other entities coming from the same source (server and file) which are loading ok.
It almost seems like the problem is happening on the Datalake, or wherever dataflows saves the data.
I also just noticed than when the power query opens to edit the entities in the data flow, the one that does not show in desktop appears to very briefly (< 1 sec) have a blue question mark on it, which disappears. There is no indication after than that there is any issue with the entity.
Based on your problem description, I added new entity from a different table in the same database, and that one seems OK. So there appears to be an issue with one table, not the database or the server. No closer to a resolution though.
Hi,
I have the same issue since today - working on this since more than 8 hours to find a solution. Was getting crazy as I seemed to be the only one...
I have the following scenario created for support:
Ticket Nr. 119111921001401
This is happened to multiple of my dataflows so the complete architecture is currently "offline"...:/
Would be happy about a solution, even if this get's fixed in the background!
Cheers Philipp
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.