Forum Discussion
Power Bi Report with Multiple sources Automatic refresh .
Hello Anonymous
My Gateway settings match yours.
My dataset I think is the problem, please see screen shot below;
There is a red X for the Business Central connection.
Regards
GrahamR99
The red X next to business central connect was the key here; I had to create a connect to business central in the gateway, once this was done the download worked.
Hi GrahamR99 ，
Based on your description, it seems that your report has now added a on-premise data source SQL Server in addition to the original data source Microsoft Dynamics Business Central. Microsoft Dynamics Business Central is a cloud data source, so it‘s not necessary to install and configure a gateway for scheduled refreshe. But SQL Server is a on-premise data source and it is required. Gateway is essential if there are data sources that are available on-premises and not on the cloud. The gateway acts as the bridge between the Power BI Cloud Service and the on-premise data sources through a secured network. You can refer to the following blog to install and configure the gateway for scheduled refresh.
REFRESH DATA FROM AN ON-PREMISES SQL SERVER DATABASE
Also, you can review the content in the following links for more details of every step...
1. Install an on-premises data gateway
Install an on-premises data gateway
The Power BI Gateway; All You Need to Know
2. Configure gateway in Service
Manage your data source - SQL Server
3. Configure schedule refresh
One more thing to note is that your report contains both on-premises and cloud data sources, please select the option Allow user's cloud data sources to refresh through this gateway cluster to ensure that you can merge or append on-premises and cloud data sources in the same query.
Best Regards
Hello Anonymous
I have a gateway already setup, and I have other reports that connect to the same on-prem source.
I think it trying to connect to the cloud using the gateway, is that correct?
There is a setting in the gateway management page to allow refresh of cloud data sources through the gateway. In essence you are providing free compute resources to Microsoft (in addition to paying for the capacity). You may or may not want to do that.
We have seen scenarios where a mix of on-premise and SharePoint sources required this to be enabled.
Hi GrahamR99 ,
Could you please provide some screenshots with your Gateway Cluster Setting and Dataset settings info just like below screenshot? Before share them with us, please mask the sensitive data for them. Thank you.
Did you checked the option "Allow user's cloud data sources to refresh through this gateway cluster"?
Gateway Cluster Settings
Please make sure the related data source(SQL Server) has been included in the dataset...
Dataset settings
In addition, please make sure the credential info of all data sources are correct and configure schedule refresh properly.
Data source credentials and configure schedule refresh
Refresh On-Premises Data in Power BI using On-Premises Data Gateway
Best Regards
Hello Anonymous
My Gateway settings match yours.
My dataset I think is the problem, please see screen shot below;
There is a red X for the Business Central connection.
Regards
GrahamR99
