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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 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.