Forum Discussion

catcollector's avatar
catcollector
Helper I
6 years ago

On-Premise Data Gateway and Dataflow

I have a two-fold question that I will wrap into a single post.    I have added multiple data sources in my on-premise data gateway (ODBC Athena and Redshift data sources). I see it when I go to S...
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi catcollector ,

 

For ODBC data sources, three authentication methods are provided, Basic, Anonymous, Windows.

For Amazon Redshift, 'Basic' is used.

 

Best regards,
Lionel Chen

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

catcollector's avatar
catcollector
Helper I
6 years ago

v-lionel-msft Just curious, do you know how to get the data sources populated when using Dataflow as opposed to having business partners type in the dsn (ODBC) or server & database for Redshift? Once they key in those items, the username and password is populated encrypted, but it seems inefficient to have them key that in every time they use Dataflow. 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi catcollector ,

     

    I don't quite understand the problem you met, maybe you can refer to the official document.

    Creating and using dataflows in Power BI 

     

    Best regards,
    Lionel Chen

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