Forum Discussion

helenah's avatar
helenah
Icon for Helper I rankHelper 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
helenah's avatar
helenah
Icon for Helper I rankHelper 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
Icon for Memorable Member rankMemorable 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
    Icon for Helper I rankHelper 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