Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In the latest two updates of PowerBI, the attached .pbix file issues an error, which is perports is an Authorization error, when in fact the error appears to be a bug. Here's a link to my oneDrive.
https://1drv.ms/u/s!AuVy-U2vn_fU6tpJi4TYheBvQUgBQA
To duplicate this problem, you'll have to replace the PWA URL with a valid one, and your PWA site will need to have some AssignmentBaseline data.
If a Microsoft employee wants to make direct contact with me, I'll provide an OData account they can use to duplicate the problem on our site, but I'm hoping that they'll have an internal site that will suffice.
In the Advanced Query editor, you'll see that you can enable and disable the error by commenting/uncommenting a few lines of code:
let Source = OData.Feed(#"PWA Site URL" & "/_api/ProjectData/[en-us]"), AssignmentBaselines_table = Source{[Name="AssignmentBaselines",Signature="table"]}[Data], // problem -- uncomment the next two lines #"Filtered Rows" = Table.SelectRows(AssignmentBaselines_table, each ([BaselineNumber] = 0)), #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"BaselineNumber", "ProjectId", "AssignmentId", "AssignmentBaselineBudgetCost", "AssignmentBaselineCost", "AssignmentBaselineFinishDate", "AssignmentBaselineStartDate", "AssignmentBaselineWork", "ProjectName", "TaskId", "TaskName"}), // workaround -- comment the two lines above, and uncomment this next one // #"Removed Other Columns" = Table.SelectColumns(AssignmentBaselines_table,{"BaselineNumber", "ProjectId", "AssignmentId", "AssignmentBaselineBudgetCost", "AssignmentBaselineCost", "AssignmentBaselineFinishDate", "AssignmentBaselineStartDate", "AssignmentBaselineWork", "ProjectName", "TaskId", "TaskName"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Other Columns",{{"ProjectId", "Project Id"}, {"AssignmentId", "Assignment Id"}, {"AssignmentBaselineBudgetCost", "Assignment Baseline Budget Cost"}, {"AssignmentBaselineCost", "Assignment Baseline Cost"}, {"AssignmentBaselineFinishDate", "Assignment Baseline Finish Date"}, {"AssignmentBaselineStartDate", "Assignment Baseline Start Date"}, {"AssignmentBaselineWork", "Assignment Baseline Work"}, {"ProjectName", "Project Name"}, {"TaskId", "Task Id"}, {"TaskName", "Task Name"}}) in #"Renamed Columns"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.