Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PaulusD
Resolver II
Resolver II

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 II
Resolver II

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 II
Resolver II

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors