Forum Discussion
Kudo CollectorScheduled refresh exits with error with Sharepoint Folder datasources
Hi guys,
I had to build a report with Sharepoint folders as datasources. When I refresh the report from Power BI Desktop, the report refreshes just fine. When I try to refresh the dataset from Power BI service, the refresh stops with an error "There was an error when processing the data in the dataset. The command has been canceled. Table: XYZ.". The credentials are correct.
Have you met such an issue? Any idea how to solve it?
Thanks a lot.
Tsanka
PS: I have registered a case for this but haven't received any info from the support team yet.
Posted the same in the Power BI FB group as well:
With the help of Microsoft support guys it became clear that the solution of the issue is:
(a) you have to have Microsoft.ACE.OLEDB.12.0 installed on the computer from which the report is published
(b) you must not use Excel 2003 files (.xls)
3 Replies
v-juanli-msftCommunity Support
Hi Tsanka
From the error message, the issue seems related to the Provinces table.
Does this table 'XXX' exist in current dataset? Please open file in desktop to check the applied steps under query editor mode to see whether there existing any error.
Best Regards
Maggie
TsankaMaggie,
Thanks for the input.
Table XXX exists and there are is no error in the query editor.
The strange thing is that XXX actually varies - sometimes the error message is for XXX, sometimes for another table in the dataset. I have attached a screenshot showing that two refreshes run within 1 minute produce one and the same error but for different tables from the dataset.
Best regards
Tsanka
- Tsanka
Posted the same in the Power BI FB group as well:
With the help of Microsoft support guys it became clear that the solution of the issue is:
(a) you have to have Microsoft.ACE.OLEDB.12.0 installed on the computer from which the report is published
(b) you must not use Excel 2003 files (.xls)