Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Cannot schedule refresh for datasets with MS Exchange Online data

Hi everyone,   I have gotten a report that loads data from MS Exchange Online (Office 365) email account. On desktop, things are working as expected. I went to data sources > online services > exch...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Anonymous,

    When the dataset only contains Exchange online data source, no gateway is required. But when we combine online data sources and on-premises data sources in a single dataset, gateway is required to refresh the dataset.

    In your scenario, you combine Exchange online data source and on-premises SSRS data source in a single dataset, gateway is required to refresh dataset. However, since it is not possible to add the Exchange data source within enterprise gateway, you can use personal gateway as a workaround. For more details, please review this idea:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,


What do you mean that "other data sources(SSRS reports)"?

Could you please post a screenshot about data sources in your Power BI Desktop when you combine Exchange online and other data sources? You can go to File -> Options and settings ->Data source settings in Power BI Desktop to check data sources.

Besides, there is no exchange option under enterprise gateway, thus when you combine Exchange online data source and other on-premises data sources, you need to use personal gateway to refresh your dataset.

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous

 

Thanks for your reply.

 

If I understand correctly, you are actually saying that I need to install Personal Gateway in addition to having the Enterprise Data Gateway, for Exchange Online accounts? This doesn't make sense as this actually kills the purpose of Exchange being Online!

 

And, sorry to confuse you with my previous post. As I mentioned in my original post, my PBIX has two types of data sources, SSRS reports & an Exchange Online mailbox. I have Enterprise Data Gateway installed on my network which enables me to refresh data from my on-prem data sources including SSRS, and there's nothing wrong with the SSRS part, as I mentioned in my previous post where I listed down the scenarios. 

 

 

Here's a screenshot of my data sources from the PBIX.

 

Data sources from PBIX

 

Thanks

Kaz

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous,

    When the dataset only contains Exchange online data source, no gateway is required. But when we combine online data sources and on-premises data sources in a single dataset, gateway is required to refresh the dataset.

    In your scenario, you combine Exchange online data source and on-premises SSRS data source in a single dataset, gateway is required to refresh dataset. However, since it is not possible to add the Exchange data source within enterprise gateway, you can use personal gateway as a workaround. For more details, please review this idea:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Anonymous

       

      Thanks for getting me that URL.  

       

      Thanks

      Kaz