Forum Discussion
No gateway to access data source data-but working in PBI Desktop
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... : ))))
Super UserThat 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
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?
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... : ))))