Forum Discussion

BWL's avatar
BWL
Helper II
8 years ago

Scheduled refresh MS exchange PowerBI Service

Dear all, I connected to our Microsoft Exchange Server with PBI Desktop and build a couple of reports. Once I uploaded them to the PBI Service I had to configure the Data Source credentials. I...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

BWL，

Have you entered UPN  on account dialog box in Power BI Desktop? Could you please post gateway log here?

Regards,
Lydia

  • BWL's avatar
    BWL
    Helper II
    8 years ago

    Anonymous,

    I did the whole thing again, recreated the reports and published again to the service.
    At least I got a connection right now and it says that it refreses, but I see no data at all.

    Here the steps: 

    1.  Select "Microsoft Exchange". Entered my emailadress + password. Then I got the following notification:



    2. Load the data, created the report and published it to the service
    3. Tried to refresh the report and everything went blank.
    4. Checked settings, and it shows that everything works. 


     
    I just don't understand what I'm doing wrong. :(
     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      BWL,

      The above screenshots mentions that you don't need gateway to refresh your dataset, it seems that you are connecting to Exchange Online but not on-premises Exchange. 

      If you are connecting to Exchange online, please use Microsoft Account option in Power BI Desktop and use OAuth2 option in Power BI Service.

      Regards,
      Lydia

      • BWL's avatar
        BWL
        Helper II
        8 years ago

        Anonymous,


        I changed it to Microsoft Account in PowerBI Service and used the OAuth2 option.
        Two erros  occured:


        PowerBI Desktop


        PowerBI Service:

         

        Message:ErrorNonExistentMailbox: The SMTP address has no mailbox associated with it. Table: Mail.