Failed to refresh ODATA connected table

[LeonLiang]

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!

[v-juanli-msft]

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:

1. https://community.dynamics.com/nav/f/34/t/171804

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. 

2. https://forum.mibuso.com/discussion/67770/solved-do-not-have-the-following-permissions-on-tabledata

Best Regards

Maggie

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]

@v-juanli-msft 

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.