Forum Discussion

mohammed_essam's avatar
6 years ago
Solved

Dataflow Entity not visable in PowerBI Desktop

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"

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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