Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Direct Query Source

Hello,

 

I would like to practice working with Direct Query sources.

 

Is there a Microsoft o any other source we can connect to for learning purpose?

 

Thanks,

Tamir

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    You can install SQL Server Express edition on your machine, then connect to the SQL Server database with DirectQuery mode in Power BI Desktop.

    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    You can install SQL Server Express edition on your machine, then connect to the SQL Server database with DirectQuery mode in Power BI Desktop.

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you Anonymous

       

      After I figured out that I need to put a dot ("." ) in the Server name field I got the databases within SQL Server Express edition.

       

      Regards,

      Tamir