Dataflow Entity not visable in PowerBI Desktop

[mohammed_essam]

Hello,

I have recently added new dataflow and data entity by copying M code from Desktop version and paste into Data Flow of Workspace, now I can see dataflow from PowerBI desktop App but can't see entities are nested under it ?? do you have any idea? even after did refesh and data refresh many time, close and reopen PBI Desktop App?

Please check code below and advice ?

let
  Source = SharePoint.Files("https://XX.sharepoint.com/sites/XX/", [ApiVersion = 15]),
  #"Filtered hidden files" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
  #"Invoke custom function" = Table.AddColumn(#"Filtered hidden files", "Transform file", each #"Transform file"([Content])),
  #"Renamed columns" = Table.RenameColumns(#"Invoke custom function", {{"Name", "Source.Name"}}),
  #"Removed other columns" = Table.SelectColumns(#"Renamed columns", {"Source.Name", "Transform file"}),
  #"Expanded table column" = Table.ExpandTableColumn(#"Removed other columns", "Transform file", Table.ColumnNames(#"Transform file"(#"Sample file"))),
  #"Changed column type" = Table.TransformColumnTypes(#"Expanded table column", {{"Source.Name", type text}, {"TermName", type text}, {"DistrictName", type text}, {"SchoolName", type text}, {"StudentLastName", type text}, {"StudentFirstName", type text}, {"StudentMI", type text}, {"StudentID", Int64.Type}, {"StudentDateOfBirth", type date}, {"StudentEthnicGroup", type text}, {"StudentGender", type text}, {"Grade", type text}, {"MeasurementScale", type text}, {"Discipline", type text}, {"NormsReferenceData", Int64.Type}, {"WISelectedAYFall", Int64.Type}, {"WISelectedAYWinter", type text}, {"WISelectedAYSpring", type text}, {"WIPreviousAYFall", Int64.Type}, {"WIPreviousAYWinter", type text}, {"WIPreviousAYSpring", type text}, {"TestType", type text}, {"TestName", type text}, {"TestStartDate", type date}, {"TestDurationMinutes", Int64.Type}, {"TestRITScore", Int64.Type}, {"TestStandardError", type number}, {"TestPercentile", Int64.Type}, {"FallToFallProjectedGrowth", Int64.Type}, {"FallToFallObservedGrowth", Int64.Type}, {"FallToFallObservedGrowthSE", type number}, {"FallToFallMetProjectedGrowth", type text}, {"FallToFallConditionalGrowthIndex", type number}, {"FallToFallConditionalGrowthPercentile", Int64.Type}, {"FallToWinterProjectedGrowth", type text}, {"FallToWinterObservedGrowth", type text}, {"FallToWinterObservedGrowthSE", type text}, {"FallToWinterMetProjectedGrowth", type text}, {"FallToWinterConditionalGrowthIndex", type text}, {"FallToWinterConditionalGrowthPercentile", type text}, {"FallToSpringProjectedGrowth", type text}, {"FallToSpringObservedGrowth", type text}, {"FallToSpringObservedGrowthSE", type text}, {"FallToSpringMetProjectedGrowth", type text}, {"FallToSpringConditionalGrowthIndex", type text}, {"FallToSpringConditionalGrowthPercentile", type text}, {"WinterToWinterProjectedGrowth", type text}, {"WinterToWinterObservedGrowth", type text}, {"WinterToWinterObservedGrowthSE", type text}, {"WinterToWinterMetProjectedGrowth", type text}, {"WinterToWinterConditionalGrowthIndex", type text}, {"WinterToWinterConditionalGrowthPercentile", type text}, {"WinterToSpringProjectedGrowth", type text}, {"WinterToSpringObservedGrowth", type text}, {"WinterToSpringObservedGrowthSE", type text}, {"WinterToSpringMetProjectedGrowth", type text}, {"WinterToSpringConditionalGrowthIndex", type text}, {"WinterToSpringConditionalGrowthPercentile", type text}, {"SpringToSpringProjectedGrowth", type text}, {"SpringToSpringObservedGrowth", type text}, {"SpringToSpringObservedGrowthSE", type text}, {"SpringToSpringMetProjectedGrowth", type text}, {"SpringToSpringConditionalGrowthIndex", type text}, {"SpringToSpringConditionalGrowthPercentile", type text}, {"RITtoReadingScore", type text}, {"RITtoReadingMin", type text}, {"RITtoReadingMax", type text}, {"Goal1Name", type text}, {"Goal1RitScore", Int64.Type}, {"Goal1StdErr", type number}, {"Goal1Range", type text}, {"Goal1Adjective", type text}, {"Goal2Name", type text}, {"Goal2RitScore", Int64.Type}, {"Goal2StdErr", type number}, {"Goal2Range", type text}, {"Goal2Adjective", type text}, {"Goal3Name", type text}, {"Goal3RitScore", Int64.Type}, {"Goal3StdErr", type number}, {"Goal3Range", type text}, {"Goal3Adjective", type text}, {"Goal4Name", type text}, {"Goal4RitScore", Int64.Type}, {"Goal4StdErr", type number}, {"Goal4Range", type text}, {"Goal4Adjective", type text}, {"Goal5Name", type text}, {"Goal5RitScore", Int64.Type}, {"Goal5StdErr", type number}, {"Goal5Range", type text}, {"Goal5Adjective", type text}, {"Goal6Name", type text}, {"Goal6RitScore", type text}, {"Goal6StdErr", type text}, {"Goal6Range", type text}, {"Goal6Adjective", type text}, {"Goal7Name", type text}, {"Goal7RitScore", type text}, {"Goal7StdErr", type text}, {"Goal7Range", type text}, {"Goal7Adjective", type text}, {"Goal8Name", type text}, {"Goal8RitScore", type text}, {"Goal8StdErr", type text}, {"Goal8Range", type text}, {"Goal8Adjective", type text}, {"TestStartTime", type text}, {"PercentCorrect", Int64.Type}, {"ProjectedProficiencyStudy1", type text}, {"ProjectedProficiencyLevel1", type text}, {"ProjectedProficiencyStudy2", type text}, {"ProjectedProficiencyLevel2", type text}, {"ProjectedProficiencyStudy3", type text}, {"ProjectedProficiencyLevel3", type text}, {"AccommodationCategory", type text}, {"Accommodations", type text}, {"TypicalFallToFallGrowth", Int64.Type}, {"TypicalFallToWinterGrowth", Int64.Type}, {"TypicalFallToSpringGrowth", Int64.Type}, {"TypicalWinterToWinterGrowth", type text}, {"TypicalWinterToSpringGrowth", type text}, {"TypicalSpringToSpringGrowth", type text}, {"ProjectedProficiencyStudy4", type text}, {"ProjectedProficiencyLevel4", type text}, {"ProjectedProficiencyStudy5", type text}, {"ProjectedProficiencyLevel5", type text}, {"ProjectedProficiencyStudy6", type text}, {"ProjectedProficiencyLevel6", type text}, {"ProjectedProficiencyStudy7", type text}, {"ProjectedProficiencyLevel7", type text}, {"ProjectedProficiencyStudy8", type text}, {"ProjectedProficiencyLevel8", type text}, {"ProjectedProficiencyStudy9", type text}, {"ProjectedProficiencyLevel9", type text}, {"ProjectedProficiencyStudy10", type text}, {"ProjectedProficiencyLevel10", type text}}),
  XXSchool = Table.AddColumn(#"Changed column type",  "XXSchool", each Text.BetweenDelimiters([Source.Name],"_",".",1,0)),
  XXStudentNumber = Table.AddColumn(#"XXSchool",  "XXStudentNumber", each Text.BetweenDelimiters([Source.Name],"_",".",1,0) & Number.ToText([StudentID]) ),
  #"Transform columns" = Table.TransformColumnTypes(XXStudentNumber, {{"XXSchool", type text}, {"XXStudentNumber", type text}})
in
  #"Transform columns"

[v-shex-msft]

Hi @mohammed_essam,

Where are you dataflow hosts? Common workspace or premium capacity? have you used the same account as you create the dataflow on service side? Have you switched the sign-in account after your success get data?

AFAIK, current get data from power bi dataflow are based on sign-in account credentials, if you change this, these old data tables will verify failed.

Regards,

Xiaoxin Sheng

[amitchandak]

@ImkeF , can you help.

[ImkeF]

Hi @mohammed_essam 

have you checked if the entity has actually been filled?: https://community.powerbi.com/t5/Service/DataFlow-table-is-empty-when-connecting-with-Desktop/td-p/6...  

[mohammed_essam]

Unfortunatly, I have did all steps mentioned in linke below, I have refreshed all dataflows, clear all permissions and reconnect to dataflow again, but I still can only see dataflow without any entities inside on PBI Desktop? However I can only see entities under PowerBI web portal,  please advice?

[Anonymous · Accepted solution]

 Had same problem a few hours ago and it was solved after I installed last version of PowerBI Desktop.

[mohammed_essam]

It worked after upgrading PowerBI Desktop to the latest version.