Forum Discussion

helenah's avatar
helenah
Helper I
9 years ago

64 bit Access database engine error when I have Power BI 32 bit

Hello,   I originally had Power BI 64 bit and Office 32 bit and was trying to get a connection to file https://www.eia.gov/petroleum/gasdiesel/xls/psw18vwall.xls   It did not work out because of ...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago
helenah wrote:

Hello,

 

I originally had Power BI 64 bit and Office 32 bit and was trying to get a connection to file https://www.eia.gov/petroleum/gasdiesel/xls/psw18vwall.xls

 

It did not work out because of the .xls file format, and I solved the issue by changing my Power BI version to 32 bit.

 

Now I am able to connect to the data source and everything works fine in Power BI Desktop.

 

However, when I try to refresh the report in the Power BI website, I get the following error message:

 

Last refresh failed: Fri May 19 2017 12:04:33 GMT+0300 (FLE Daylight Time)
Cannot connect to the mashup data source. See error details for more information.Hide details

Underlying error code: -2147467259
Underlying error message: Excel Workbook: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.NotFound
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: 28f57023-9dcd-4c62-9bfd-b3467868b468
Request ID: 1b331c3a-7920-44f9-0156-98771f685c13
Time: 2017-05-19 09:04:33Z

 

I don't understand why 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required!

 

I have checked the mentioned website and followed the instructins (all now 32 bit) but still not working.

 

I don't want to install Office 64 bit since not all other Office add-ons of my workplace work with 64 bit version.

 

What to try next?

helenah

Power BI gateways are 64bit so they would require 64bit drivers. You may have to install 64bit drivers.

See Power BI Gateway does not support 32 bit Access DB

 

  • helenah's avatar
    helenah
    Helper I
    9 years ago

    Eric_Zhang

     

    Thank you. I also found that link after I posted and also commented it with my issue.

     

    Since I have Office 32 bit I cannot install 64 bit Engine. I am stuck here since my company's ICT organization advises against changing my Office to 64 bit. We will still give it one try and install 64bit Engine to the enterprise gateway, do you think that helps?

     

    What is a bit misleading is that I started using the 32 bit versions based on instructions on this page: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-access-database-errors/

     

    I think it should state on that page that one should NOT use the 32 bit version since then one cannot do scheduled refresh :(

    • CahabaData's avatar
      CahabaData
      Memorable Member
      9 years ago

      I'm a little confused - in that when I go to: https://www.eia.gov/petroleum/gasdiesel/xls/psw18vwall.xls

       

      it immediately downloads the file and doesn't present a web page at all

       

      so is this topic concerning a local file xls?   as I don't see any connectibility by Power BI Service to this as a web page.....

      • helenah's avatar
        helenah
        Helper I
        9 years ago

        Hi CahabaData,

         

        I fetch the data as I would fetch it from a web source:

         

        let
            Source = Excel.Workbook(Web.Contents("https://www.eia.gov/petroleum/gasdiesel/xls/psw18vwall.xls"), null, true),
            #"Data 1" = Source{[Name="Data 2"]}[Data],
            #"Changed Type" = Table.TransformColumnTypes(#"Data 1",{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}, {"Column6", type text}, {"Column7", type text}, {"Column8", type text}, {"Column9", type text}, {"Column10", type text}, {"Column11", type text}, {"Column12", type text}, {"Column13", type text}}),
            #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
            #"Promoted Headers1" = Table.PromoteHeaders(#"Promoted Headers", [PromoteAllScalars=true]),
            #"Promoted Headers2" = Table.PromoteHeaders(#"Promoted Headers1", [PromoteAllScalars=true]),
            #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers2",{{"U.S. No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"East Coast No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"New England (PADD 1A) No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"Central Atlantic (PADD 1B) No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"Lower Atlantic (PADD 1C) No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"Midwest No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"Gulf Coast No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"Rocky Mountain No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"West Coast No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"California No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"West Coast (PADD 5) Except California No 2 Diesel Retail Prices (Dollars per Gallon)", type number}, {"Column13", type number}, {"Date", type date}})
        in
            #"Changed Type1"

         

        This is not a local file and it is updated by a third party in a frequency I am not aware of (monthly). I want to always have the latest data available in my dashboard without the need to download the file as a local excel file.

         

        If there is an alternative method of doing this, I am happy to learn.

         

        Helena