From the course: Power BI Dataflows Essential Training
Join today to access over 25,500 courses taught by industry experts.
Connecting to databases
From the course: Power BI Dataflows Essential Training
Connecting to databases
- [Instructor] You can connect to many kinds of databases in the Power BI cloud. The database you want to access will likely depend on the databases your own organization utilizes to store and query data. This is not a course on databases or Azure, but identifying them as database connection types in Power BI data flows, means that you can explore how to tap into their potential. To set up the database connection, you will typically need credentials like the server name, the database name, and any related login credentials to access them. It's also helpful to know what tables you want to query or bring in the data from, especially if you're working with a large database. SQL server is an example of a well known relational database. It consists of tables within a database that we can query to create sets of useful data. An organization hosts a server like SQL server on premises instead of in the cloud. Conversely…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.