Forum Discussion

Anuradha_Sinha's avatar
Anuradha_Sinha
New Member
5 years ago
Solved

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

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 err...
Need Help
  • Anuradha_Sinha's avatar
    Anuradha_Sinha
    5 years ago

    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's avatar
veenashenolikar
Helper V
5 years ago

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's avatar
Anuradha_Sinha
New Member
5 years ago

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.