MS Project "Priority" Field

[maynaje]

How can I have Power BI Desktop display the project "Priority" field, which I set in the Project Information dialog box in an MS Project Online file?  It's a standard project-related field that should be automatically available when I "get" my MS Project Online data using the Power BI > Power BI Datasets option in Power BI Desktop.  Thank you!

[v-piga-msft]

Hi @maynaje,

Based on your description, it seems that you have get data from MS Project Online in Power BI Service, but the "Priority" field cannot be displayed in Power BI Desktop when you get data with Power BI Datasets connector?

Could you see the "Priority" field in Power BI Service after getting data from  MS Project Online?

If it is convenient, please share some screenshots to describe your scenario in more detaisl.

Best Regards,

Cherry

[maynaje]

Hi, Cherry.  I just realized that I didn't answer your question.  After importing the MS Project Online data into Power BI Desktop, I could not see the "priority" field.  Power BI Desktop pulls an "issue" and "risk" priority field, which we don't even use, but --- for some reason --- it does not pull the project's priority field.  I'm hoping you can work some magic for us ... or tell me how I can force Power BI to pull the project's priority field, which is pretty basic, fundamental information.  Thank you!

[maynaje]

Thank you, Cherry.  Here are three screenshots.  The first screenshot is of the MS Project file's Project Information dialog box and its Priority field.  I desperately want this field to display when I pull the MS Project Online data into Power BI, but it does not.

The second screenshot is of my Power BI Desktop Home tab.  As you can see, it will not let me "get data" or "enter data" again.  Because Power BI Desktop "gets" MS Project Online data via Power BI Online as a "live" data source, it will not let me get, enter, or import more data.

The third screenshot is of my Power BI Desktop Modeling tab.  As you can see, it will not let me create a "new table" or "new column."  If Power BI cannot make the MS Project file's Priority field available to me as a data field in Power BI, I'm thinking of researching if I can somehow create my own "measure," but it would be a clumsy attempt.  I'd rather have the data field pulled by Power BI and given to me automatically.

 

Thank you for your help.  I hope you have a good day.

Jessie