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.
I have Power BI via our 365 Business subscription. We also have Project Online which I need to build some dashboards for. I have Power BI talking to PWA fine and data is being pulled through but it doesn't seem to be pulling all the data across. For example, any custom (enterprise) text fields are not showing in Power BI.
Needing some assistance in trying to work out what I have done wrong please.
Solved! Go to Solution.
Hi @nogi,
Based on test, project online connector seems not import these custom fields to power bi. In my opinion, I'd like to suggest you contact that team to know more about this connector.
BTW, when I try to use odata to connect project online at power bi desktop, my test column appears.
Regards,
Xiaoxin Sheng
Hi @nogi,
Based on test, project online connector seems not import these custom fields to power bi. In my opinion, I'd like to suggest you contact that team to know more about this connector.
BTW, when I try to use odata to connect project online at power bi desktop, my test column appears.
Regards,
Xiaoxin Sheng
Yes, I ended up using ODATA and it all comes through now.
Can I ask how you were able to import ODATA through. I've tried using the url (https://<sitename>.sharepoint.com/sites/pwa/_api/); however my custom fields are still not showing. I'm using Power BI online
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.