Forum Discussion
Live connection to SQL server data base
Hi Anonymous ,
You may consider using the DirectQuery mode to connect to SQL.
DirectQuery: No data is imported or copied into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.
Use DirectQuery in Power BI Desktop
Are you confusing DirectQuery and live connection mode?
Power BI Connection Types: DirectQuery, Live, or Import?
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Anonymous ,
You may consider using the DirectQuery mode to connect to SQL.
DirectQuery: No data is imported or copied into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you’re always viewing current data.
Use DirectQuery in Power BI Desktop
Are you confusing DirectQuery and live connection mode?
Power BI Connection Types: DirectQuery, Live, or Import?
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data