Forum Discussion

jvanveelen's avatar
jvanveelen
Regular Visitor
1 year ago

Planner tasks (buckets) in PowerBI

Hi, 

 

Maybe there is already a answer, but i'm unable to find it. My question is.

In planner.cloud.microsoft i create a plan with multiple buckets and each bucket has some activity tasks.
With powerautomate flow i create a flow that will export this plan to a json file.
In BI desktop i want to visualise this json file with progress. The only thing is when i import this file all my Buckets are ID's instead of the name. 

 

Does someone know how to set this to the displayname of the bucket in the PowerBI table? 

 

Thanks

Need Help

1 Reply

  • audreygerred's avatar
    audreygerred
    Icon for Super User rankSuper User
    1 year ago

    In the json file is there a field for the name of the IDs? If not, can you see if you can create an export with the names and the ID? If not, can you determine what names go with what ID, if so, you can create a dimension table with the ID and the text name, then create a relationship from the ID in the dim table to the ID in teh table created from your json file.