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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
juanlopezmeyer
Frequent Visitor

SQL Server - Import data

Hi everyone;

 

I have connected a SQL Server to Power Bi. I am importing the data. I need to update/refresh the data everytime that the file is opened. Is that possible? I do not find that option. I think that in previous versions that was done automatically but with the latest version I have to click Refresh to update the information. 

 

Thanks!!!

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @juanlopezmeyer,

 

Current power bi desktop not support this feature.(I test with both import and direct query mode)
Perhaps you can share this requirement to ideas.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @juanlopezmeyer,

 

Current power bi desktop not support this feature.(I test with both import and direct query mode)
Perhaps you can share this requirement to ideas.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

To my knowledge, I think there is noway to update the data everytime you opended the .pbix file... If you publish your .pbix file to service then you can schedule the refresh under the Gateway. 

So you think that the scheduled refresh through the gateway is the only option?

Anonymous
Not applicable

Yes I think so...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.