Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to understand how the Bind to Gateway in group request works.
Indeed I used it to connect the dataset of my power bi to a gateway containing several datasources.
I gave the 2 ids of my datasources.
What I do not understand is the mapping which is just between the databases present in the PBI dataset and the selected datasources.
Thank you
Solved! Go to Solution.
Hi @Ybam
When we refresh dataset in Service , we need a gateway .So how to manage datasource in Gateway in Service and map the datasource to the dataset become vital . We will explain your question in two parts based on the fact that the gateway is already running normally .
(1)Add datasource in gateway in Service . If we want to get data in Service from local data source , we need to configure a standard gateway and enter the credentials for the local data source to make sure we can access the data successfully . The step of entering credentials of the data source is adding datasource in gateway .Specific operations can refer to the link below .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources
(2)Map the datasource to the dataset . We have configured the datasource in gateway , that means we can access the data from local data sources , but due to the multiple datasets and data sources , Service how to refresh accurately ? In this case, we have to manually match the dataset and data source, which is the mapping you mentioned. As the picture shows :
After finishing the above series of operations, we will set up a scheduled refresh to ensure that the data set is automatically updated in a planned manner .
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Ybam
When we refresh dataset in Service , we need a gateway .So how to manage datasource in Gateway in Service and map the datasource to the dataset become vital . We will explain your question in two parts based on the fact that the gateway is already running normally .
(1)Add datasource in gateway in Service . If we want to get data in Service from local data source , we need to configure a standard gateway and enter the credentials for the local data source to make sure we can access the data successfully . The step of entering credentials of the data source is adding datasource in gateway .Specific operations can refer to the link below .
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources
(2)Map the datasource to the dataset . We have configured the datasource in gateway , that means we can access the data from local data sources , but due to the multiple datasets and data sources , Service how to refresh accurately ? In this case, we have to manually match the dataset and data source, which is the mapping you mentioned. As the picture shows :
After finishing the above series of operations, we will set up a scheduled refresh to ensure that the data set is automatically updated in a planned manner .
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Data sources will be matched between dataset and gateway based on the connection string . Warning: This is case sensitive!
Not sure what specifying the data sources is trying to achieve for this call.
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |