cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Darrell21
Frequent Visitor

My Data won't refresh

Hello guys,

 

 

im having errors on refreshing my powerbi report on web.

here's the error

 

Message:The command has been canceled. Table: CustomerList.

Cluster URI:WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity ID:2a48ac5f-88ff-4bc3-890b-c61369b12bfe

Request ID:b03515d5-6c63-4dc7-a1af-f1f9a78bfaf2

Time:2018-08-31 02:41:01Z

i also have file that is almost 500 MB 

  • all file are in excel
  • i am PRO user my files are in sharepoint folder.
  • the file size had error is 1.7MB

 

please help.

 

thanks in advance

6 REPLIES 6
v-yuezhe-msft
Microsoft
Microsoft

@Darrell21,

Are you able to refresh the report in Power BI Desktop?

Regards,
Lydia

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

was trying since yesterday, but still fails. any suggestion?errorerror

@Darrell21,

The above error mentions about CY 2017 Sales query, are you able to connect to this specific Excel in a new PBIX file? And do you store Excel in on-premises SharePoint or online SharePoint?

Regards,
Lydia

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

Hi @lydia

I Have folder from my desktop which automatically sync to sharepoint. Whenever i change a file from there it sync right away. Like one drive. Havent tried connecting it into a new PBIX file.

Thanks
Darrell

@Darrell21,

Please check if you can connect to the source in new PBIX file and then check if new rows appear. Also do you connect to SharePoint online folder or on-premises SharePoint folder?

Regards,
Lydia

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

@v-yuezhe-msft

 

 

ok i will feed back soon. thanks

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors