Forum Discussion

LeonLiang's avatar
LeonLiang
Frequent Visitor
7 years ago

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-msft's avatar
    v-juanli-msft
    Community 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.

    • LeonLiang's avatar
      LeonLiang
      Frequent Visitor

      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.