Error on scheduled data refresh while no error from client for same data

[Anuradha_Sinha]

Hello all,

I have created a power bi report for sharepoint list and published it to the web succesfully. Everything is fine until i refreshed the data on web using schedule refresh option, 

The error- Have tried found people having this issue but no luck to get the solution yet. If some one had same issue and solution for it, please reply. Appreciate the help as earliest.

The column 'ID' of the table wasn't found.. The exception was raised by the IDbCommand interface.

[Anuradha_Sinha · Accepted solution]

Hello All, 

Thanks for replying all on this question but we finally concluded that issue was with the permissions for the account through which the data schedule to refresh, after changing that account , we didn't face this issue.

[veenashenolikar]

Hi @Anuradha_Sinha 

There seems to be some  reference to a column named "ID" in your data. Were you getting this error while refreshing from desktop?

Also is it possible for you to share some data/transformation from power query to help replicate the issue

Regards,

Veena Shenolikar

[Anuradha_Sinha]

Hello,

I am getting this error only on web schedule refresh not on client desktop.

it is just a simple list of sharepoint as a data source and not much , the only think=g i noticed today is my data which loads in Power BI shows two different IDs in the list data where i don't have do in my list.

Not sure if this is issue, if yes too , i have never see this yet where i have made many reports sucessfully in power BI , any idea if there is any settings of list causing this here ?

Thanks for your response.