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.
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?
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
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.
The red x for Business Central is ok, just an indication that no gateway is required for that connection. Your actual issue is that the gateway cannot reach the SQL server. Firewalls?
