Forum Discussion

Sylvester_OEC's avatar
Sylvester_OEC
Frequent Visitor
4 years ago
Solved

Couldn't load the data for this visual

Hi everyone! I am using the PowerBI Pro TRIAL version and have a Direct Query connecting to Azure SQL server databases. I am able to build and successfully publish my report on the PowerBI service -...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Sylvester_OEC 

    “Import” and “Direct Query” are different in how data is acquired and stored . When you connect to Azure SQL database with Import mode , the data will be stored in your pbix file , and after you publishing the report to Service , the data is in the dataset .But if you connect to Azure SQL database with Direct Query mode , you get the data by sending query to your data source , in this situation , Service need to keep a connection with your data source , so you need to enable single sign-on (SSO) using Azure Active Directory (Azure AD) OAuth2 for your end users.

    Microsoft has an official document detailing how to connect to Azure SQL Database in Service , it will help you have a better understanding .

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect

     

    Best Regard

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.