There is no gateway to access the data source message

[Bulvers]

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

[Maria1983]

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 😞 

[v-kelly-msft]

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!

[Bulvers]

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]

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

[Bulvers]

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.

[GilbertQ]

That really does not make much sense.

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

[Greg_Deckler]

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".