1 Dec’17

BISQL Live Connection in Power BI


In this article, we will learn how to configure Live connection for SQL in Power BI.


  1. Power BI  Licence
  2. SQL Server Database Engine.
  3. Power BI Gateway (Refer this link to configure Power BI Gateway)

Steps to Connect SQL Live in PowerBI:

  1. Open PowerBI Desktop
  2. Click Get Data and Select SQL Server.
  3. In the SQL Connection details, select DirectQuery Mode for Live Connection.
  4. Once the Data is loaded, you can create Power BI Dashboard. DirectQuery enabled status is visible at the right bottom of the Power BI Desktop.
  5. Before publishing the Dashboard, login into Power BI Service.
  6. Under Manage Gateway, we must add a data source for SQL Server.
  7. Go back to Power BI Desktop and publish the Power BI dashboard.
  8. In the Power BI Service, under the Reports you will be able to see the published Live SQL dashboard.
Written by

Anjali Hemmadi

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • How to hide the Delete button in a page in Microsoft Dynamics NAV

    21 March’ 2018

    Introduction: By default, Delete button is visible on every page in the Home tab but if we do not want the user to dele...

    Read more
  • Managing mailbox through Email Archiving

    20 March’ 2018

    Introduction: Email can fill your Outlook Inbox quickly – new messages, replies, and forwards. Before you know it, yo...

    Read more
  • Workaround to Report.SAVEASPDF in NAV 2018

    20 March’ 2018

    Objective: In NAV 2017 Emailing the PDF by running the report using Report.SAVEASPDF is now not allowed in NAV 2018. Th...

    Read more
  • Dynamics 365 Client Diagnostics

    15 March’ 2018

    Main cause of Performance Issues: Bandwidth and latency are the primary characteristics which affects the performance o...

    Read more
  • Closing Blind Shift in MPOS and CPOS in Dynamics 365 for Retail

    15 March’ 2018

    Manual For closing Blind shift in POS: Blind shifts terminate the currently ongoing shift and when logged in a new shif...

    Read more