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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

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