Live connection to SQL server data base

[Anonymous]

Hi,

I have the data from SQL want co connect to Power bi with LIVE connection . How to do it?? Can you guide me on this. 

[Anonymous · Accepted solution]

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

[ibarrau]

Hi. That's not possible. Live connection it's only available for sources like Analysis Services and Power Bi Datasets. You can refresh up to 8 times importing data with pro or up to 48 times a day with premium. An alternative would be connecting with Direct Query. That will send a query for each interaction from the user. The database should be really optimize to perform fast, otherwise it will be a 15 seconds waiting each time you click something. There are microsoft docs about good practices for direct query if you are interested.

I hope that helps,