Forum Discussion
Data Flows: "Empty Table" query type --> data set does not return any records
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
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("xxxxxxxxxxxxxxxxxxx [[THIS WAS A MASSIVR STRING THAT I REMOVED BECUAE OF THE CHARACTER LIMIT", BinaryEncoding.Base64), Compression.Deflate)), let _t = (type text) meta [Serialized.Text = true] in type table [#"Column 1" = _t, #"Column 2" = _t, #"Column 3" = _t, #"Column 4" = _t, #"Column 5" = _t, #"Column 6" = _t, #"Column 7" = _t, #"Column 8" = _t, #"Column 9" = _t, #"Column 10" = _t, #"Column 11" = _t, #"Column 12" = _t, #"Column 13" = _t, #"Column 14" = _t, #"Column 15" = _t, #"Column 16" = _t, #"Column 17" = _t, #"Column 18" = _t, #"Column 19" = _t, #"Column 20" = _t, #"Column 21" = _t]),
#"Promoted headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
#"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"DateKey", type number}, {"FullDate", type date}, {"DateName", type date}, {"DayOfWeek", type number}, {"DayNameOfWeek", type text}, {"DayOfMonth", type number}, {"DayOfYear", type number}, {"WeekdayWeekend", type text}, {"WeekOfYear", type number}, {"MonthName", type text}, {"MonthOfYear", type number}, {"IsLastDayOfMonth", type text}, {"CalendarQuarter", type number}, {"CalendarYear", type number}, {"CalendarYearMonth", type date}, {"CalendarYearQtr", type text}, {"FiscalMonthOfYear", type number}, {"FiscalQuarter", type number}, {"FiscalYear", type number}, {"FiscalYearMonth", type text}, {"FiscalYearQtr", type text}})
in
#"Changed column type"