cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulusD
Resolver I
Resolver I

Unable to add datasource to gateway

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:

PaulusD_0-1672302969040.png

 

When scheduling the refresh:

PaulusD_1-1672302994701.png

 

Adding the source to the gateway:

PaulusD_2-1672303011443.png

 

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!

1 ACCEPTED SOLUTION
PaulusD
Resolver I
Resolver I

Hi @v-zhangti ,

 

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

Refresh now runs as per schedule.

 

Thanks for assisting though 🙂

View solution in original post

2 REPLIES 2
PaulusD
Resolver I
Resolver I

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
Community Support
Community Support

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.

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors