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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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
May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors