Forum Discussion
Project Online Pack - Accessing Calculated Fields/Columns
Hi Everyone,
Does anyone know how to access the calculated fields/columns that are provided in the Project Online starter pack? There are some useful fields there and am trying to use these in Power BI desktop, but can't seem to access them anywhere. When I use the online version and try to edit the report(s), no information is provided.
5 Replies
StarwoodTech Don't know much about the starter pack, unless you are talking about the Content Pack. The Power BI Service (Online) doesn't have any of the modeling capabilites (You can't add or access calculated columns/measures), you need to do that in the Desktop. Since Project Online still isn't an accessible data source in the Desktop (to my knowledge) - you would need to access the data in a different way. (Odata for example).
Yes, it was the Contact Pack. So the trick how to open these for editing in Power BI desktop, which I can't seem to do because I don't have a dataset file as I would with my own reports. Unless these are available somewhere. It would be helpful and mutually beneficial for Microsoft to make these available, since it would promote use through knowledge I'd think.
StarwoodTech Some of the content packs are available as data sources in the Desktop, but there are far more that are not. You will not be able to use a Content Pack as a datasource in the Desktop.
You need to access the information from Project Online in a supported data source. One way I know you can do that is via the Odata feed, but you will need to manually pull down the data and create your own model.
