none
日历见解连接失败 fail to connect RRS feed

  • Question

  • Excel模板里有个日历见解,下载打开后第一件事就要登录,可是登录以后无论怎么连接就是失败,还请哪位指点一下下,谢谢。
    我先后试过O365国际版E5帐户和国内版E3帐户,都连接不上。

    i found an interesting template called "日历见解", but fail to connect.

    is there anyone know how to deal with it?

    my account is o365 e3

    thank you


    在单元格里横行的小妖同学

    QQ:76332468

    http://pure-shadow.blog.sohu.com/

    专业方向:EXCEL操作

    Wednesday, August 1, 2018 12:43 PM

Answers

  • Hi there. What do you see if you do the following:

    • Open the template
    • Click the Data tab
    • Click "Get Data" (under the Get & Transform Data section)
    • Click "Launch Power Query Editor"
    • Select each query and click Advanced Editor

    I'm curious where it's trying to connect to.

    Ehren

    Thursday, August 2, 2018 7:05 PM
    Owner
  • Hi pureshadow. I asked around internally, and apparently this template was deprecated due to a number of issues.

    If you'd like to get it working, you'll need to open the Power Query editor and update any Source steps that have the following formula:

    = Exchange.Contents()

    Instead they should say:

    = Exchange.Contents("youremailaddress@contoso.com")

    Give that a try and let me know if it works.

    Ehren

    Thursday, August 2, 2018 7:40 PM
    Owner

All replies

  • Hi pureshadow. Is your Exchange account a cloud account or on-prem? If it's cloud, signing in via your Microsoft account creds should work.

    Ehren

    Wednesday, August 1, 2018 8:34 PM
    Owner
  • thanks for your reply.

    i did it. my o365 account and my microsoft accout, both failed.


    在单元格里横行的小妖同学

    QQ:76332468

    http://pure-shadow.blog.sohu.com/

    专业方向:EXCEL操作

    Thursday, August 2, 2018 9:22 AM
  • i found some information, but nothing about failure connection: https://support.office.com/en-us/article/manage-your-calendar-with-the-calendar-insights-template-for-excel-2016-7edbeb88-99ca-403f-a394-7e957d3d3f40?ui=en-US&rs=en-US&ad=US

    i tried some other way to connect the exchang and it's well done.

    except these data are nothing about the Calendar Insights.


    在单元格里横行的小妖同学

    QQ:76332468

    http://pure-shadow.blog.sohu.com/

    专业方向:EXCEL操作

    Thursday, August 2, 2018 12:28 PM
  • Hi there. What do you see if you do the following:

    • Open the template
    • Click the Data tab
    • Click "Get Data" (under the Get & Transform Data section)
    • Click "Launch Power Query Editor"
    • Select each query and click Advanced Editor

    I'm curious where it's trying to connect to.

    Ehren

    Thursday, August 2, 2018 7:05 PM
    Owner
  • Hi pureshadow. I asked around internally, and apparently this template was deprecated due to a number of issues.

    If you'd like to get it working, you'll need to open the Power Query editor and update any Source steps that have the following formula:

    = Exchange.Contents()

    Instead they should say:

    = Exchange.Contents("youremailaddress@contoso.com")

    Give that a try and let me know if it works.

    Ehren

    Thursday, August 2, 2018 7:40 PM
    Owner
  • Thank you

    在单元格里横行的小妖同学

    QQ:76332468

    http://pure-shadow.blog.sohu.com/

    专业方向:EXCEL操作

    Friday, August 3, 2018 9:22 AM