Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Making a auto refresh Power BI report using Azure DocumentDB and other data sources = impossible?

Hi   Our organization is moving towards new ERP-system using DocumentDB as a database solution. However, while testing the new DocumentDB data in Power BI Desktop and other data sources in the same...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

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: 

 

https://community.powerbi.com/t5/Integrations-with-Files-and/power-BI-gateway-connection-issues/td-p/84197

 

Regards,

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Okay, thanks for the info. Any tips on this? Can I install Personal gateway on the same on-premises server as our On-Premises Gateway?

BR,
Atte H

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    8 years ago

    Anonymous

     

    Yes, you can install both Personal and On-Premise gateway on same machine. 

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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/