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

     

     

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!