Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I'm getting this error message
There is no gateway to access the data source XXXXXVerify the gateway connection configuration on the and make sure all required data sources are added to the selected data gateway.There is no gateway to access the data source {0}. Verify the gateway connection configuration on the {1} and make sure all required data sources are added to the selected data gateway.Close
Solved! Go to Solution.
Hi @7ballp25 ,
For this type of error, my guess is that you are using a data source connected in direct query mode.
If your data source is located locally, the data source should be added to the local gateway so that you can see the data on the report when using direct query. Also if you want to refresh the dataset, you need to add the data source to the gateway regardless of the direct query or import mode of the local data source.
For how to deploy the gateway, you can refer to the following related documents.
Guidance for deploying a data gateway for Power BI - Power BI | Microsoft Docs
Setting Up A Power BI Data Gateway: 3 Easy Steps - Learn | Hevo (hevodata.com)
Setting up Power BI Data Gateway (sqlshack.com)
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @7ballp25 ,
For this type of error, my guess is that you are using a data source connected in direct query mode.
If your data source is located locally, the data source should be added to the local gateway so that you can see the data on the report when using direct query. Also if you want to refresh the dataset, you need to add the data source to the gateway regardless of the direct query or import mode of the local data source.
For how to deploy the gateway, you can refer to the following related documents.
Guidance for deploying a data gateway for Power BI - Power BI | Microsoft Docs
Setting Up A Power BI Data Gateway: 3 Easy Steps - Learn | Hevo (hevodata.com)
Setting up Power BI Data Gateway (sqlshack.com)
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
would you mind providing some details? What type of data source is it? Does that data source require the use of a gateway for service refresh?
User | Count |
---|---|
24 | |
21 | |
11 | |
11 | |
10 |
User | Count |
---|---|
49 | |
31 | |
20 | |
18 | |
15 |