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

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

Thank god for this thread.  We were pulling our hair out and troubleshot from sql to dataflows to M coding to the measures.  I thought I was going crazy.

jcullum Regular Visitor
Regular Visitor

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

Thanks for confirming the hypothesis.  Now we just need microsoft to fix dates properly in the dataflows 

intelabhinav Frequent Visitor
Frequent Visitor

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

Weird, I have a JSON export of my dataflow from couple of days back, it has dates in it. When I import it and refresh, it works perfectly fine. It is when I make any change to any table (no date field changes), it starts to collapse on tables with date fields. I hope Microsoft is working on a fix.
mhalkjaer Visitor
Visitor

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

Just wanted to confirm that we are having the same issue, date field showing as unclassified and making tables non-visible in PowerBI Desktop.

For us the temporary fix has been to change all date fields to date/time, which made it accessible from Desktop.
Then we converted them back to date type in PowerBI Desktop.

mgreez Frequent Visitor
Frequent Visitor

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

Summary of what I experienced:

  • Failed Dataflows, both manual and scheduled
  • Even in Dataflows that have been running without intervention, they prompt for credentials
  • Dataflow Entities with DATE columns have been somehow changed to UNCLASSIFIED and are likely the cause of the error.  Entities that do not include DATE columns work as expected.
  • When attempting to manually refresh a Dataset that includes Dataflows in question, it fails.  In the Power Query editing, the error code is "Key does not match any rows", meaning it can't find the Dataflow

Workaround:

  • Edit Dataflow entities that have column type UNCLASSIFIED to TEXT.  I titled the Custom Step "Text Workaround Step", so I can delete it after MSFT fixes.
    • I initially started changing from UNCLASSIFIED TO DATETIME (as mentioned above), but there were a few instances where after clicking "Save and Close", it reverted back to UNCLASSIFIED, so I just switched them all to TEXT
  • Refresh data in Power BI Desktop to update your Dataset
Timaru_Golf Frequent Visitor
Frequent Visitor

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

I have an open ticket on what it now apears is this issue and I am also seeing refresh issue accessing sharepoint so don't if this is another issue of this change.

uberdube Frequent Visitor
Frequent Visitor

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

I couldn't agree more the absolute relief I felt stumbling across this thread by chance.. I've almost spent an entire day and night  going insane over it deleting & re-creating entities, importing jsons, even creating entirely new workspaces... this is amidst also randomly finding out last week that there was apparently also a bug with the Advanced Compute engine preview that was potentially effecting dataflow refreshes.. (mine started randomly failing (not to mention the endless refresh issues I've had with Dataflows so far already) but I beleive that's now been resolved)...  all these sanity-questioning bugs (lol) are frustrating when attempting to implement a new & unfamiliar technology.. and really spoiling my experience with Dataflows so far.. it's not been a good week 😞

 

Anyhow, thanks to this thread I've successfully had my Entities re-appearing in the Dataflows folders in the Power BI Service by following the workaround suggested earlier, changing the data type to DateTime (or Text also works). I really hope this gets fixed asap (and that others suffering the same pain stumble across this thread quickly too!!)

 

2019-11-19_0327_001.png2019-11-19_0328_001.png

Highlighted
rargyle Frequent Visitor
Frequent Visitor

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

Thanks to those of you who have pointed out the exact cause of the issue, and for a workaround. I've just had a couple of days pulling my hair out too, and then raised a support ticket with MS about it. They have been very responsive and helpful and after much trace capturing etc they have pointed me to this thread, and also informed me:

 

It is already escalated to the Product Group Team and they said that they are working on it and shared the ETA for the issue.

"We're aware of the issues and planning a QFE path. Current plan is to have it deployed to ROW by end of week."

jvanegmond Frequent Visitor
Frequent Visitor

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

Same issues here, must be related to the recent announcement about "Additional Number/Date/DateTime/Duration transformations UX" described here: https://powerbi.microsoft.com/en-us/blog/50-new-features-in-dataflows-this-month/ 

 

My workaround:

- Export the json

- Replace every occurrence of

"dataType": "date"

 with

"dataType": "dateTime"

- Import the json, you'll get a new name "Oldname"+"(1)" and a new quid for your dataflow

- Try to refresh it and validate the results

- Reconnect to the dataflow by changing the guid in power bi desktop to the new guid using the advanced editor

let
    Source = PowerBI.Dataflows(null),
    Workspace = Source{[workspaceId="62828a48-e232-4c95-833e-xxxxxxxxxxxx"]}[Data],
    Dataflow = Workspace{[dataflowId="9804c7f0-e368-4cb2-a7cc-xxxxxxxxxxxx"]}[Data], //Change this guid
    Dataset = Dataflow{[entity="Entityname"]}[Data],
etc

 

leed Member
Member

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

Same here.

Issue:

1/ import json files : everything works correct, can modify existing query, PB desktop is able to reach out to the dataflow.

2/ add a new table :

-dataflow shows all the entity including the new one

-PB desktop only catches the new one, all the old one are not displayed.

-Tried : (none of them work)

options > setting > uncheck combine data (although I dont combine any data)

disable then reenable

delete and recreate a new query

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 (1,744)