Forum Discussion

Camila_IB's avatar
Camila_IB
Frequent Visitor
3 years ago

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 ...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi 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

Camila_IB's avatar
Camila_IB
Frequent Visitor
3 years ago

Hello v-jingzhang ,

 

After much googling I was finally able to resolve the issue.

 

At the beginning of this week my team and I did a clean up of the custom project fields that we use in Project Online. Turns out that there are certain specific words that can cause issues with the OData flux, such as "Project", "Category" etc...

 

 

 

Basically you have to be carefully when naming the custom fields, as some words are reserved in some way:
 

 

This was the post I found that was helpful: https://techcommunity.microsoft.com/t5/project-support-blog/project-online-using-reserved-custom-fie...

 

I should have realised it was something to do with the fields as the issue appeared a day after we did that clean up in Project Online.

 

Really appreciate your help with this! Hopefully this can be useful for other people running into the same issue in the future.

 

Have a great day.

 

Best,

Camila