Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

There was an error when processing the data in the dataset

Hello,

 

while publishing a report on web i am getting "there was an error when processing the data in the dataset" this error.

 

I am attaching the snap of error.(Table name is highlighted and it is always changes ).

 

On searching on community, I got some solutions, but it didnt worked for me.

 

According to one of the solution, I have downloaded the report from services and refreshed it,while refreshing I received an error that <ms access database name> could not be use.The file is already open.

 

But on checking I found that file was closed.

 

Some Information about my report- 

  1. I am using MS Access as backend data source.
  2. there are no any inactive relations created between tables 

Regards,

VivekC

 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  friend,

     

    i had the same bug. -  odata source from microsoft  dynamics 365

     

    what solve my problem is that  i have removed merged tables in the power query.

     

    thanks