Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
4 years ago
Solved

Power Bi Report with Multiple sources Automatic refresh .

Hello I had a report that just downloaded data from Cloud Microsoft Dynamics Business Central.   I have added a new table to it which is connect to a on prem SQL Server database table.   When it...
Need Help
  • GrahamR99's avatar
    GrahamR99
    4 years ago

    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

  • GrahamR99's avatar
    GrahamR99
    4 years ago

    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.

GrahamR99's avatar
GrahamR99
Resolver I
4 years ago

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?

 

lbendlin's avatar
lbendlin
Super User
4 years ago

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.