Get data from website with Excel 365 for Mac

[mwollert]

Looking for some help with a workbook that gets data from a website. I want to be able to use the workbook on both a Windows DesktopNotebook and also a MacBook Air.

I am using a Power Query and it works fine on the PC but will not work on the Mac. On the Mac I get I a message "Security warning: External Data Connections have been disabled." When I click "Enable content", I get a error message "[Expression.error] the import web.page matches no exports. Did you miss a module reference?"

Looking for some advise on how to create a connection that will work on both Windows and iOS.

I'm using the Advanced Editor in Windows to create the link that works fine on the PC.

let
    Source = Web.Page(Web.Contents("https://www.tsp.gov/fund-performance/share-price-history/")),
    Data0 = Source{0}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Data0,{{"Date", type date}, {"L Income", Currency.Type}, {"L 2025", Currency.Type}, {"L 2030", Currency.Type}, {"L 2035", Currency.Type}, {"L 2040", Currency.Type}, {"L 2045", Currency.Type}, {"L 2050", Currency.Type}, {"L 2055", Currency.Type}, {"L 2060", Currency.Type}, {"L 2065", Currency.Type}, {"G Fund", Currency.Type}, {"F Fund", Currency.Type}, {"C Fund", Currency.Type}, {"S Fund", Currency.Type}, {"I Fund", Currency.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Date", Order.Asending}})
in
    #"Changed Type"

The website in question is : https://www.tsp.gov/fund-performance/share-price-history/

Any assistance will be greatly appreciated. Thanks

 

[alansidman]

You need to be subscribed to the Insider version

Excel Update: Power Query Editor for Mac - Excel Campus

Find out how to use the new Power Query Editor for Macs, learn the current limitations, and determine if it's the best option for you.

www.excelcampus.com

 

[mwollert]

You need to be subscribed to the Insider version

Excel Update: Power Query Editor for Mac - Excel Campus

Find out how to use the new Power Query Editor for Macs, learn the current limitations, and determine if it's the best option for you.

www.excelcampus.com

Thank you for the response. I am a subscribed to Insider version and my Office Apps show up to date, but I still cannot get the link to a website to work.

I don't see a option to edit the code for the link either on the Mac like I see on the Windows version.


Here is all I can see for the link on the Mac.


View attachment 71046



And this is what I am use to in Windows

Any suggestions?

 

[Jim Gordon]

The HTML connector has not yet been released for Excel Mac.