Forum Discussion
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!
2 Replies
- v-juanli-msftCommunity Support
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.- LeonLiangFrequent Visitor
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.