Forum Discussion
Power BI Desktop Dataset Multiple sources - Scheduled refresh
I have a PBIX file that has been developed against two SQL server databases. These are on two different hosts. The report refreshes fine on the desktop. The PBIX is configured for data import (not direct query) of course because that's not acceptable for PBIX files with multiple sources still I believe.
I have created an on premises data gateway connection for both databases involved.
I have published and successfully scheduled refresh of datasets that use either of the two SQL server database connections I configured on the gateway, so I know it can successfully find those connections based on the host name and DB name match. The gateway option is not grayed out.
When I attempt to publish the original file with two data sources, it publishes but there is no ability to schedule it on the enterprise gateway. That option is grayed out. Is this expected behavior and can someone help me out with a specific link to where it's documented that is or is not supported (multiple data sources within the same data set being scheduled to refresh via the gateway)?
Jeremy_Rogers As you describe it, this should work. If both the SQL Server DB data sources are set up on the same gateway, and there are no other data sources, the report using both together shouldn't have any issues...
Are you positive the connections in the PBIX file match exactly to the datasource connections you've set up in the gateway?
5 Replies
Jeremy_Rogers As you describe it, this should work. If both the SQL Server DB data sources are set up on the same gateway, and there are no other data sources, the report using both together shouldn't have any issues...
Are you positive the connections in the PBIX file match exactly to the datasource connections you've set up in the gateway?
I found a connection to one of the data sources had been set up on two different gateways. I removed the connection definition that wasn't on the same gateway and re-published, with no improved results. So, yes, now both connections exist on the same gateway ONLY (previously one of the connections was defined on two gateways).
Is there a specific time multiple data source for the same data set refresh became available that you know of or has it been there for a very long time?
Jeremy_Rogers Did you completely delete the dataset from the Service? Is that possible for you to do, or do you have dashboards built/shared on top of the dataset already?
