cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Darrell21 Frequent Visitor
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
Moderator v-yuezhe-msft
Moderator

Re: My Data won't refresh

@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.
Darrell21 Frequent Visitor
Frequent Visitor

Re: My Data won't refresh

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

Moderator v-yuezhe-msft
Moderator

Re: My Data won't refresh

@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.
Darrell21 Frequent Visitor
Frequent Visitor

Re: My Data won't refresh

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
Moderator v-yuezhe-msft
Moderator

Re: My Data won't refresh

@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.
Darrell21 Frequent Visitor
Frequent Visitor

Re: My Data won't refresh

@v-yuezhe-msft

 

 

ok i will feed back soon. thanks

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 45 members 777 guests
Please welcome our newest community members: