Unable to add datasource to gateway

[PaulusD]

Hi all,

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!

[PaulusD · Accepted solution]

Hi @v-zhangti ,

Wierdly deleting the report and re-publishing it solved the issue.

Refresh now runs as per schedule.

Thanks for assisting though 🙂

[v-zhangti]

Hi, @PaulusD 

Please refer to the following links in the hopes of helping you.

Solved: Unable to add new data source to Gateway - Microsoft Power BI Community
Solved: Unable to add references to datasource - Microsoft Power BI Community

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.