I'm having some issues with a datasource within the service.
Here's the situation.
-I have a report published in the service running on an ms sql database. No issues here.
-I have a dataset published in the service with exchange rates. This dataset refreshed daily and runs fine.
In the first report, I use data from the second report (the exchange rates). This is done via a direct query from within the desktop.
The setup has been running fine for almost a year now (!), until this week....
I can't for the life of me add the exchange rates table to te gateway so that the first report can be updated daily.
Although it says this is optional, my experience is that everything that needs refershing has to be added to a gateway.
I'm running the latest version of the on-premises data gateway.
The problem child:
When scheduling the refresh:
Adding the source to the gateway:
It thows a credential related problem that I don't understand...
Btw I'm a an admin in the workspace and a power platform admin in our tenant..
Any help is much appreciated!