Forum Discussion

Jimmy Lelièvre's avatar
Jimmy Lelièvre
Copper Contributor
Apr 13, 2017
Solved

Excel "Email Insights" not showing any data

We're currently experiancing problems with the Excel templetes, particularly the "Email Insights" template. On my computer I'm able to log in but no https://ibb.co/bQiE35 is shown. On other computers, people aren't able to log in. 

Can somebody help me out with this?


Systems: Windows 10 + O365

  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 19, 2017

    Hi Jimmy,

     

    Yes, it looks like that's not specific Excel problem. In addition to TechNet you may publish on answers.microsoft.com (that's kind of Microsoft support) and on community.powerbi.com. Better on all of them, more chances you'll find someone who know both tenant configuration and how Exchnage connector for Power Query.

     

    Good luck 

17 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Hi Jimmy,

     

    Never heard about this template, tried it right now and it works. Something to clarify

    1) Do you use Exchange Online (Office365 mail) or on-premises one

    2) Did you follow literally to login instructions (connect with Exchange account using your O365 username, etc.)

    3) If in Ribbon Data menu select Show Queries do you see any errors new queries name (other words they are refreshed in your case or not)

     

    • Jimmy Lelièvre's avatar
      Jimmy Lelièvre
      Copper Contributor

      Hello Sergei,

      https://ibb.co/b0MFbQis the template I'm talking about.

      1. Yes, we use Exchange online in combination with O365.
      2. The credentials are correct. I use the same credenials for all other online MS services.
      3. https://ibb.co/jUrRi5 are the only queries I see. But nothing changes no mather what I do.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        Jimmy, does autodiscovery works for your tenant? Other words, for example, if you use Outlook 2016 are there any problems with connecting it to Exchange Online?

Resources