Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.