Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Bulvers
Frequent Visitor

There is no gateway to access the data source message

Hello,

 

I am publishing a new report to my workspace and I am running into an error that I haven't seen before. 

 

I am getting the message "There is no gateway to access the data source (specific source)" message for a data source that I use in multiple reports across my workspace.

 

When I go to the Gateway settings for this report... all data sources are assigned and all connection tests are good and status at the top says "Running on (gateway computer)" with a green checkmark.

 

Has anyone experienced something similar?

 

Thanks!

B

 

7 REPLIES 7
Maria1983
Advocate I
Advocate I

We have the exact same issue! All connection work fine and the dataset can be updated, but the report and app using the datasets have no data and have the exact same cryptic message: 

 

There is no gateway to access the data source (specific source). 

 

What gateway is this??

 

We have tried re-publishing the report, and this solves the problem. But the problem appears again after some hours 😞 

 

PowerBI error.jpg

 

 

v-kelly-msft
Community Support
Community Support

Hi @Bulvers

 

Check the similar thread below:

https://community.powerbi.com/t5/Report-Server/Report-couldn-t-access-the-data-source/td-p/761986

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

Checked that thread, but unfortunately not using any RLS in my reports. Ill keep digging, wonder if possibly some settings were changed to allow access to the gateway above me that I am unaware of?

GilbertQ
Super User
Super User

Hi there

If you open the PBIX and go into data source settings can you make sure that all the data sources do have it setup in the Power BI Service




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yep, all data sources are set up properly in the service. To make things even weirder, I published the exact same report to a separate workspace and that one works fine. Exact same report on two different workspaces.

That really does not make much sense.

Possibly something is wrong in that App Workspace or with that version of the PBIX?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Greg_Deckler
Super User
Super User

I have not experienced anything like this. Perhaps posting a screen shot might help? 

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors