Forum Discussion
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:
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.
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.