Forum Discussion

speedramps's avatar
speedramps
Super User
6 years ago
Solved

help to create my first dataflow from a SQL table.

Hi   Please can you help me create my first dataflow from a SQL table.   I have done the following:- Installed an instance of Microsoft SQL Server Developer (64-bit) on my laptop Created datab...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi speedramps ,

     

    Dataflow will not work with a personal gateway.  If you have a personal gateway, you may like to consider uninstalling it and installing the enterprise version instead.  See more about install and setting for the enterprise gateway : What is an on-premises data gateway?.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nickyvv's avatar
nickyvv
Most Valuable Professional
6 years ago
The name of your source (server + database) has to be identical to the name in the gateway, because that is case sensitive in dataflows. So please check that.