cancel
Showing results for 
Search instead for 
Did you mean: 

Dataflows - No entity after refresh

Hi, ,

 

I am having issues with a dataflow today. I have made some changes to it earlier today and since then it is not returning any entity. During the preview, it is showing correct data but no data is shown when I connect it through Power BI Desktop. The Power BI Desktop query is not showing any entity. 

 

This may be linked to the following issues already on the Power BI Support Page

 

Customers creating a new Dataflow from the Power BI service will see the default setting "Allow combining data from multiple sources" set to true instead of false. As a workaround, customers can uncheck the setting. Engineers are working on a fix and expect it to be deployed by end-of-day 11/22/2019.

 

Thanks

Nishant

Status: Accepted
Comments
Visitor

I have the same issue. 

Some entities randomly are not accessible.

I've just created a calendar table from a blank query to limit dependencies.

Dataflow:

 

However, if try to use that dataflow in PowerBi service, there are no entities:

calendar3.png

New Member

Hi Everyone, 

 

I beleve same situation here: 

* Entities exist in the Dataflow

* Entities refresh in the Dataflow

* Entities DO NOT appear in the preview, when i connect to the Dataflows using Power BI Desktop

 

Observations:

* Smilar entities ( same code + same source) dissapppeared from multiple Workspaces. 

* Creating the new Dataflow and copy pasting the code of the dissapeared entity didnt help

* Creating new workspace and new Dataflow didnt help

* If I delete Applied Steps from dissapeared entities and try to load row data it appears back

* Closer to the end of the day other entities started to disappear

* Reports failed to refresh but Dataflows refresh BAU

 

Please share your observations and hints if you got.

 

Regards,

 

Paul

 

Member

Similar issue for me: empty dataflows on expand in the navigator, previewing data within the source dataflow works just fine.

 

Enhanced Dataflows Compute Engine is off.  My DateTime columns are listed as DateTime.

 

I submitted a support ticket and showed them the error...unfortunately I'm on Premium so they had to transfer my ticket to premium support so now I'm waiting to hear back from them.

Visitor

@jeffshieldsdev ,

the workaround provided in the first message doesn't work for me as well.

Visitor

We are experiencing the same issues. Late last week on Friday I made several edits to existing dataflows. Now the entities do no appear when accessing the dataflow as a data source in Power BI Desktop.

 

Does anyone know if Microsoft is aware of the issue, and working towards resolving it?

Visitor

I feel a little less alone now.  I thought I did something.

 

I reached out to our Microsoft Rep.  This issue took down one of our production reports with hunreds of daily users.

Member

I submitted a ticket regarding the empty dataflows while browsing in the navigator.  They just told me its now a known bug and will be fixed in 4 weeks.

I reached back out--is there a workaround, is there something I can do different?...I can't wait 4 weeks to start sharing dataflows with my company. 😞

Visitor

Same issue here. No choice to connect my data without the dataflow...

Frequent Visitor

Same thing with me. Tried different things, no use. If there is more they two steps in PQ, it becomes unvisible when trying to connect to dataflow.

Frequent Visitor

I had the same issue last week and found a solution that worked fine.

The entities that were no longer appearing had at least one field formatted as Date. Edited the dataflow to switch those fields to Date/Time and after refreshing the entities show up again...

Once ingested the data from the dataflow, change the field back to Date.