Showing results for 
Search instead for 
Did you mean: 
LeonLiang Frequent Visitor
Frequent Visitor

Failed to refresh ODATA connected table

Hi Team,


When I was refreshing an existing table, it prompted out the following error. I didn't modify anything. The error will prompt out everytime now. I have checked that my account and odata connection is still valid. The same table can be loaded again if I completely re-download it, whereas I don't want to redo all my work on the exisiting one. Can anyone help? Highly appricate your help!


Odata refresh failed.PNG

Community Support Team
Community Support Team

Re: Failed to refresh ODATA connected table

Hi @LeonLiang 

Which datasource is it?

What kind of account is yours?

Is the Sales invoice header "modify" a simple column or a column which contains list of records or tables as below?


As searched, some similar problem got the following suggested answers:


check if the table is in your customer license.

check the table permission settings (table properties)

check the user permissions for that tabledata

Which is the table number? If the table is from customer range (50.000 - 99.999) you should verify if it's supported by your license. 




Best Regards



Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

LeonLiang Frequent Visitor
Frequent Visitor

Re: Failed to refresh ODATA connected table


There is no such a column header called "Modify".


The error prompted out when I was refreshing the data source, whereas PowerBI thought that I was trying to modify something to the data but not having enough permission......


The data source is the 'Posted sales invoice' from our MS Dynmaics 365 system.