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

     

     

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

sidharthaa's avatar
sidharthaa
Regular Visitor
9 years ago

Did you change the second part like i mentioned in the post - the source in your Query??

If you go to the step for Navigation, you should see it there. I am not sure what you choose as your data source, but in my case it was SharePoint folder.

 

I had to specify the name of the file in the source "---.xlsx" 

 

  • olivierlenard's avatar
    olivierlenard
    Frequent Visitor
    9 years ago

    HI,

     

    After going into each step, i discovered that i created a filter on xlsb. this is the one blocking PowerBI services.


    So conclusion:

    - Powerbi desktop works with all type of extension

    - Powerbi Services does not works with xlsb (ok with xlsm).

     

    thanks!