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

  • sidharthaa's avatar
    sidharthaa
    Regular Visitor
    9 years ago

    Hi,

     

    Update on the issue  - 

    I am using "Sharepoint folder" as the data source to set up connection to an excel file. 

    I noticed that I also get an error if i refresh the data using the powerbi dashboard - 

     

     

    If I looked at the Query settings , there were errors in the transform query because it was listing few other files .png and .mht that could not be parsed.

     


     

    Like I mentioned in the previous post , this was a site created via MS Team and the folders in the library "Documents" 

    is used by Teams to store files. These additional files were the ones that caused my issue. 

     

    When I refresh the data set , it gave the below error ( some how the errror was misleading )

     

     

    Once I removed the files from the Site, the DataSet refresh and the refresh from the PowerBI desktop was fine.

     

    Seems like a bug ???

    I am looking at ways to filter / select only the file when setting up of the data source. Can't seem to figure it out.

     

    Cheers,
    Sidharth

     

     

     

     

     

    • sidharthaa's avatar
      sidharthaa
      Regular Visitor
      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

       

       

      • olivierlenard's avatar
        olivierlenard
        Frequent Visitor
        9 years ago

        Hi,

         

        I also have the same issue and it blocks when we invoke the custom function (the one that combine files).

         

        I added as well filter, but nothing works, it keeps on failing as soon as I use the combine function.

         

        Could you help ? Do you have any idea ?

         

        Bests,

         

        Olivier LN