How to connect to Project Online Data with Direct Query or Live

[Derrick_225]

Hi all.

I am a new to Power BI. I have manage to access Project online using OData Feed. I can create basic reports (list of project by status,..) but I need to refresh data in PowerBi in order to have them display in my report.

Is it a way to configure a direct connection to my report so any change to Project Online can be reflected in my report.

Best Regards

[v-lid-msft]

Hi @Derrick_225 ,

Based on my research, it doesn't support to connect to OData data source using DirectQuery mode. You can review this article to see supported data source in DirectQuery mode.

Sorry for that We can not found an effective solution to meet your requirement,The standard custom connector SDK seems only support use Direct Query with the ODBC driver currently. Perhaps you vote to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13873722-direct-query-option-for-...

Best regards,

[amitchandak]

If want to use direct query, this is a list of supported databases

https://docs.microsoft.com/en-us/power-bi/power-bi-data-sources