Forum Discussion
OData connection fail, "DataSource.Error", trying to connect to "Projects" table from Project Online
Hello, I have been using an OData flux for the past 6 months to be able to create Excel reports using the data we have in Project Online. It was working great and for some reason now it just stopped ...
v-jingzhang
Community Support
Community SupportHi Camila_IB
Can you try using the same connector in Power BI Desktop to test connecting to the same table from Project Online?
Project Online: connect to data through Power BI Desktop - Power BI | Microsoft Learn
Sometimes a connector works in Power BI but doesn't work in Excel. If it can be connected in Power BI Desktop, maybe it can tell us that the table is ok so we need to find the cause from other aspects.
Best Regards,
Community Support Team _ Jing