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...
  • 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.