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

[georgebagos]

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???

[djurecicK2]

@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

[georgebagos]

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?

[georgebagos · Accepted solution]

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... : ))))

[djurecicK2]

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

[georgebagos]

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.

[djurecicK2]

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/

[georgebagos]

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.