Forum Discussion
Making a auto refresh Power BI report using Azure DocumentDB and other data sources = impossible?
Anonymous
In this scenario, if you have Azure DocumentDB and other data source within same report, you can't use On-Premise Gateway. The data source configured in gateway is for the dataset of entire report level. Now you have multiple data source within same report, you should use Personal Gateway.
See a similar thread:
Regards,
Anonymous
Yes, you can install both Personal and On-Premise gateway on same machine.
Regards,
Thanks a lot Mr. moderator. I installed Personal Gateway on the same server and my report using mixed data-sources is now working.
Last week I was googling like a mad man and didn't find this solution - that is - one cannot use mixed-data sources (cloud + on-premise) if you are using On-premises Gateway (Not Personal GW).
For example this page should be updated with this information:
https://docs.microsoft.com/en-us/azure/cosmos-db/powerbi-visualize/