Solved: Direct Query Source

Anonymous · ‎08-23-2018

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

v-yuezhe-msft · ‎08-23-2018

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-yuezhe-msft · ‎08-23-2018

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎08-24-2018

Thank you @v-yuezhe-msft

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

Direct Query Source

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024