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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
aodendaal
New Member

There was an error when processing the data in the dataset.

I've recently setup PowerBI on the web to connect to an Azure SQL database. I setup refresh scheduling but I get the message There was an error when processing the data in the dataset. and the details below (the table name changes).

 

I have a single Web App using the Azure SQL database but I stopped it and tried multiple times with the same result (again, different tables each time).

 

Message:	The command has been canceled. Table: Provinces.
Cluster URI:	WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:	fe96cbd7-3d36-4a50-8df5-b9da6bf933c3
Request ID:	c0182b22-d0fd-13ff-c059-a307dc8734cb
Time:	2017-10-22 04:20:48Z

How do I prevent these error and get the refresh working? Where can I find more information because the message is vague.

 

2 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

Hi @aodendaal,

 

From the error message, the issue seems related to the Provinces table. Please download the report from Power BI service and open it in Power BI desktop, click Refresh in desktop to see which detail error message display. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

aodendaal
New Member

Thank you, I downloaded the report and refresh the data and I got a better error description. I had duplicate data in a field being used by an inactive relationship. I deleted the relationship, re-uploaded the report and the dataset could refresh correctly.

 

It's a little annoying that the error isn't displayed on the web and you have to download the report to see what is really going on.

 

In any case, thank you for the assist.

View solution in original post

4 REPLIES 4
aodendaal
New Member

Yes, you can close the thread. Thank you!

v-qiuyu-msft
Community Support
Community Support

Hi @aodendaal,

 

From your description, the issue is solved now, right? If it is, may I close this thread? 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
aodendaal
New Member

Thank you, I downloaded the report and refresh the data and I got a better error description. I had duplicate data in a field being used by an inactive relationship. I deleted the relationship, re-uploaded the report and the dataset could refresh correctly.

 

It's a little annoying that the error isn't displayed on the web and you have to download the report to see what is really going on.

 

In any case, thank you for the assist.

v-qiuyu-msft
Community Support
Community Support

Hi @aodendaal,

 

From the error message, the issue seems related to the Provinces table. Please download the report from Power BI service and open it in Power BI desktop, click Refresh in desktop to see which detail error message display. 

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors