topic Re: There was an error when processing the data in the dataset in Report Server

There was an error when processing the data in the dataset

Anonymous — Thu, 09 Apr 2020 16:25:36 GMT

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-

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

Regards,

VivekC

Re: There was an error when processing the data in the dataset

Greg_Deckler — Thu, 09 Apr 2020 18:40:35 GMT

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Re: There was an error when processing the data in the dataset

Anonymous — Mon, 20 Apr 2020 04:48:44 GMT

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