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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
peggyh
New Member

Data Refresh

I am new to Power BI and am experiencing a few issues with my data. When I publish my report from the Power BI desktop to the service, I can see my report and my dataset in my workspace.  I have the data tied to a SQL database and the data in the tables gets refreshed via SSIS on a regular basis.  I am able to refresh the data in the data view in the desktop and republish it to the service but am not able to refresh it in the service.  I can see the error below when  try to refresh it fro within the service, but need help understanding what steps to take correct and schedule this.

 

peggyh_0-1694718392118.png

 

I would appreciate any help as I really have no idea why this isn't working.

 

1 REPLY 1
lbendlin
Super User
Super User

If your data source is on-premise then you need to set up a gateway, create the connection on the gateway,  specify the credentials, select the gateway connection for your dataset, and then maybe even re-apply the credentials too.  Easy, right?

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.