topic Re: No gateway to access data source data-but working in PBI Desktop in Service

No gateway to access data source data-but working in PBI Desktop

georgebagos — Fri, 18 Nov 2022 23:38:13 GMT

I have created a report and have connected to another dataset of mine.

Desktop report works just fine and refreshes OK but when I publish it on the service I get a message that there is no gateway to access the data......

When trying to update the connection credentials I get no options.

Have looked everywhere and don't know how to fix this.

Any help please???

Re: No gateway to access data source data-but working in PBI Desktop

djurecic — Sat, 19 Nov 2022 04:26:48 GMT

Hi georgebagos ,

If you haven't already done it, you need to install and configure a Power BI gateway.

https://powerbi.microsoft.com/en-us/gateway/

Re: No gateway to access data source data-but working in PBI Desktop

georgebagos — Sat, 19 Nov 2022 07:01:47 GMT

Yes I have a gateway installed which works for other reports.

It shows as active running in my machine

but for this one when I go to source credentials I see no options.

Re: No gateway to access data source data-but working in PBI Desktop

djurecic — Sat, 19 Nov 2022 14:19:16 GMT

Have you added the data source to the gateway?

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#add-a-data-source

Re: No gateway to access data source data-but working in PBI Desktop

georgebagos — Sat, 19 Nov 2022 14:54:16 GMT

Hey.

my data source is a dataset of my own.

so when I first published it the note on the service was that no gateway is needed as this source was already on the cloud.

but after adding a static excel to the file, all of the sudden I get a note saying that the cloud dataset can't be found. The message I get is like the picture here:

again the file was working just fine before on the service. The pbix file is also working as usual.

Re: No gateway to access data source data-but working in PBI Desktop

djurecic — Sun, 20 Nov 2022 03:41:13 GMT

georgebagos

That makes sense- since the excel file is now part of the dataset, it's saying that you need a gateway now for the dataset. Are you able to put your excel file in OneDrive or OneDrive for business? If so, something like this might let you refresh on PBI service without a gateway:

https://radacad.com/change-excel-source-in-power-bi-to-onedrive-for-business-no-gateway-needed

Re: No gateway to access data source data-but working in PBI Desktop

georgebagos — Mon, 21 Nov 2022 07:10:01 GMT

Still did't work...

I have even deleted the excel file completely and published again but didn't fix the problem.

This makes no sense. When I click in data source credentials there are no options....

I read something about a "ghost" gateway being activated and I need to disable. Could that be it?

Re: No gateway to access data source data-but working in PBI Desktop

georgebagos — Mon, 21 Nov 2022 14:14:32 GMT

So,

I finally got it working.

I changed the query completely from the static excel to the same file in sharepoint and it worked.

Apparently you can't create composite models (and publish them on the service) using local files.

You can only use online files.

But did anyone know this before?

A weekend well spent... : ))))