Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Live connection to SQL server data base

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. 
Data Protection
Dataflow
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
ibarrau
Super User
3 years ago

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,