Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

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

 

image002.jpg

 

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

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".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
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

Greg_Deckler
Community Champion
Community Champion

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".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.