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,
Hello again,
Does anybody have any idea? I have a ticket open also to MS Support and it feels quite frustrating to me, that is it even technically possible to have DocumentDB + other data sources in a single report file? MS Support is giving me vague advice like:
"
Solution 1
- Get data from cosmos using connector without ODBC
- Get data from on premise source (any data)
- Create the report and publish it
- Setup the gateway and refresh
"
Like I understand how to make reports - it is not that. How do I setup the DocumentDB data source in the Manage Gateway - setting so that I can make a report using multiple data sources in a single report - using DocumentDB + SQL server + xls-files? I have used and thus defined SQL and xls-files as a data source already because I use them in different reports succesfully. My actual sales data is being changed from SQL server to DocumentDB and this is the reason for this hubbub.
One key info might be: I have old data from on-premises server (SQL Server) and new sales data (Azure DocumentDB) appened as a new query in the Query Editor. The reason for this: we are making the switch from old system to new system next week --> we want to have clear picture of this year for the total sales so we need old + new data = whole year sales data. Might this be a problem?