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 checked multiple times, the domain\username and password are correct, but I still get the error:


Am I doing something wrong?

 

 

Need Help
Tutorial Requests

16 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    BWL,

    Do you connect to Exchange Online or on-premises Exchange? Do you use Exchange Account or Microsoft Account in Power BI Desktop to connect to the data source?

    Regards,
    Lydia

    • BWL's avatar
      BWL
      Helper II
      8 years ago

      Anonymous,

       

      On-premises Exchange. I use my Exchange Account to connect in Power BI Desktop to connect to the datasource. 

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey guys,

     

    Exactly the same problems here.

    In PBI Desktop I can only connect to the mailbox using the "Exchange Account" athentification.

    If I then upload the report to the webspace, my entered credentials (no matter which one I take) do not work.

    Any suggestions?

    • RaijuCG's avatar
      RaijuCG
      Regular Visitor
      5 years ago

       I am also facing same issue, i dont see any help in this thread. Can someone offer help ?

  • hrubesovag's avatar
    hrubesovag
    Regular Visitor
    5 years ago

    Hi, Is there a solution for this problem? I am facing a similar issue and I tried everything. Everything is fine in Power BI desktop but not in Power BI service.
    Thanks for help..