Forum Discussion

sidharthaa's avatar
sidharthaa
Regular Visitor
9 years ago
Solved

Issue with DataSet refresh - Microsoft.ACE.POLED.12.0 / External Table is not in the expected Format

  Hi,   I am getting the below error when I try to refresh the data set. "Data source terrorizes Workbook: The 'Microsoft.ACE.POLED.12.0' provider is not registered on the local machine. The 64-b...
Need Help
  • sidharthaa's avatar
    sidharthaa
    9 years ago

    I managed to find a workaround to filter the file that i needed - 

     

    Create a filtered rows step to filter based on the file that you need

     

    I had to also update the Source to select the specific file instead of "Sample File"

    Hope this helps someone!!

     

    Cheers,
    Sidharth

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

sidharthaa,

Do you connect to .xls Excel file and refresh it in Power BI Service? If that is the case, refreshing against a .xls file is not supported. As stated in this article, Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type.

To solve the above issue, please change Excel file form type .xls to .xlsx, then you are able to refresh the dataset in Power BI Service.

Regards,

sidharthaa's avatar
sidharthaa
Regular Visitor
9 years ago

Anonymous,

 

Thanks for the reply. I am using .xslx file itself.

 

However I noticed something else, though I have not got to the root of it yet. The excel is located in a SharePoint online TS which was created via Microsoft teams. If I move the excel to a normal (created via the O365 Admin) site collection, the refresh seems to work fine. I do have Full control over both the TS so have to figure out whats causing this behavior.

 

Cheers,
Sidharth