My Data won't refresh

[Darrell21]

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

[Anonymous]

@Darrell21,

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

Regards,
Lydia

[Darrell21]

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

[Anonymous]

@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

[Darrell21]

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

[Anonymous]

@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

[Darrell21]

@Anonymous

ok i will feed back soon. thanks