Forum Discussion
atgeraci
6 years agoFrequent Visitor
Dataflow entitiy not showing all fields
Hello all! So I am having an issue with my dataflow table not showing all the fields that are present when I generate the table. I added a "Day" column to the Date_Table table (please ignore the mis...
chaz2jerry
Advocate IV
5 years agoI think I have a similar issue and found the root cause. In my scenario, I created a custom column in Decimal format. Preview data in dataflow looks good, but the new column does not show up in the entity/table after refresh (as confirmed by connecting to this Dataflow table from PBI Desktop). I had this issue a couple months back, and could not confirm why it was happening. Then today I looked into the Advanced Editor (M Query) and found that the final "in" statement points to not the last query step as usual, but points to the step before I made the latest custom column. Example of the M Query having the issue. I assume this issue will be fixed when I adjust the M Query manually, not sure why it occurred in the first place.
#"step 6" = Table.TransformColumnTypes(#"Changed Type", {"SOLD_TO", type text}),
#"step 7" = Table.AddColumn(#"Changed Type1", "Sales incl Tariff", each [Sales] + [TARRIF]),
#"step 8" = Table.TransformColumnTypes(#"step 7", {{"Sales incl Tariff", Currency.Type}})
in
#"step 6"