Forum Discussion
Multiple Non-Clustered Gateways and Automatic Datasource Choices
Hi AnthonyMCUBI ,
Based on my test, it is the same to you. I didn't find any option or solution for automatic mapping to the datasource. I would suggest create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
Best Regards,
Dedmon Dai
Hi there
Unless you are clustering the Gateways together as soon as you have multiple gateways you will have to choose which gateway to use.
The reason is that you can have the same data source on multiple gateways. Now with your multiple gateways the Power BI Service does not know which one to select. So it leaves it up to the user to configure this.
GilbertQ wrote:Hi there
Unless you are clustering the Gateways together as soon as you have multiple gateways you will have to choose which gateway to use.
The reason is that you can have the same data source on multiple gateways. Now with your multiple The reason is that you can have the same data source on multiple gateways.
We did not have datasources under more than one gateway. Each gateway has it's own disjoint set of datasources. We assumed your quote was the case, actually, until we did further testing. Gateway 1 can have 0 datasources, and using Gateway 2 will still result in no automatic datasource mapping.
If it's just a "which gateway do I look for datasources under" problem, is there a way to tell Power BI programmatically when creating the dataflow? We use the C# API, and the PostImportFileWithHttpMessage function. https://docs.microsoft.com/en-us/dotnet/api/microsoft.powerbi.api.v2.imports.postimportfilewithhttpmessage?view=azure-dotnet
Thank you,
Anthony