Forum Discussion

BWL's avatar
BWL
Icon for Helper II rankHelper 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
BWL's avatar
BWL
Icon for Helper II rankHelper 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
    Icon for Helper II rankHelper 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.
    • BenjaminD's avatar
      BenjaminD
      Frequent Visitor
      8 years ago

      Hi,

       

      I'm facing a similar issue.

      My report is working well in desktop but not in power bi service.

      I'm using microsoft account and oAUth2.

       

      Furthermore, i've noticed that the Exchange source code and the Exchange Online source code are the same.

       

      I'don't understand what i'm dooing wrong.

       

      can you help me ?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      BWL,

      Have you changed to Exchange online connector in Power BI Desktop? Please use Microsoft Account authentication in Power BI Desktop, then create report there and re-publish your report.

      Regards,
      Lydia

      • BWL's avatar
        BWL
        Icon for Helper II rankHelper II
        8 years ago

        Anonymous,

        When I try to connect to Exchange Online, it gives me the error: