Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data Flows: "Empty Table" query type --> data set does not return any records

I created a new Data Flow from the Enter Data / Emty Table option. I copied in some data from Excel (DimDate Table). It is meant to be a static date lookup. I validated the table in PBIS Data Flows...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

I'm not clear about your scenario.

Could you show more details for me to analyze better?

1. original data you enter to create a data flow

2. what steps do you apply in the data flow ( you could share the code in Advanced editor to let me kown)

3. what result it shows when connecting with Power BI Desktop?

4. "Object Expansion for the Flow", "final data elements/properties"

What do these mean?

 

Best Regards
Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

4. "Object Expansion for the Flow", "final data elements/properties"

What do these mean?

 

When you use M query to connect to a complex object (like json) that has nested objects, you use M query to transform and "expand" successive nested objects. Thew M query transforms these objects into new/additional objects that may also be complex/nested.

The query follows this process to give you a final record set.

I followed this process in this query, but the record set is [empty], even though i can see the records in the M query editor in Data Flows...

 

There is a bug. Please fix it. This is about the most basic use case available. Manually entering data to the tabular model from M...