Forum Discussion

hawkerr1's avatar
hawkerr1
Regular Visitor
3 years ago
Solved

Power BI Gateway Connections - Changes to Server ID

Hi all, My current client is a heavy user of dataflows. The dataflows are connected to various SQL server databases via Gateways. The current connections are via public end points - i.e. server nam...
Need Help
  • hawkerr1's avatar
    hawkerr1
    3 years ago

    Thanks for the reply. It was helpful, but didn't really cover the problem.

    The problem is that I didn't want to have to edit hundreds of dataflows one by one. 

     

    It seems that this is the only way and it is good to have that confirmed at least. I will raise a Power BI idea for the possibility of an API which allows editing of Datasources in Dataflows. I understand why the data sources on the gateway can't be edited - because each dataflow needs to be edited in parallel.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

HI hawkerr1,

Perhaps you can try to parameterize query connection string with query parameter on desktop side. Then you can then use this parameterized query in Dataflow by creating a new source transformation and selecting the parameterized query as the source. 

After these steps, you can change the parameters on the source to dynamic effect the Dataflow data source mapping.

Regards,

Xiaoxin Sheng