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

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

    • 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!