cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
7ballp25
Regular Visitor

Unable to view my own report online - LOSING MY MIND

I'm getting this error message

 

Data source unreachable

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

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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.

lbendlin
Super User
Super User

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?

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors