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.
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
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,
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
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.