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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

0

connected directly production server (SQL) any performance issue

Dear Team

if we connected directly production server (SQL) to Power BI any performance issue to users or impact to the connected application users 

is it advisable to connect directly to saql server ?

Status: Delivered
Comments
Anonymous
Not applicable

Hi @lenijegan18004 

Connect directly to sql server does have performance issues, but it has the advantage that you have access to the latest data at all times. If you have high performance requirements then you can use Import connection mode to access SQL. 

You can refer to the blog below .

Import vs Direct Query: Here's What You Need to Know | phData

 

 

Best Regards,
Community Support Team _ Ailsa Tao