Forum Discussion

kajalraj's avatar
kajalraj
New Member
9 years ago

auto refresh report generation for project online data

I am new to Project Online. Have created arouind 50 projects in Project online with respective tasks and schedules.   Now i have to generate a real time dashboard with project reports. This repor...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi kajalraj,

 

There are two options you can try based on your requirements,

 

1. In Power BI service, connect to Project Online content pack for Power BI. Then enter credential for the data source and enable the schedule refresh.

 

 

2.  In Power BI desktop, use OData feed data source, enter your Project Web App URL with "/_api/projectdata" appended, eg:

https://qiuyunusproject.sharepoint.com/sites/pwa/_api/projectdata

 

 

Then you can create data with useful data by yourself. After finish the report, you can publish it to Power BI service, go to dataset settings and schedule refresh like first image.

 

Best Regards,
QiuyunYu