Setting Up Local SQL Server for Power BI Desktop
Associated Blog: https://algo-hunter.net/blog/powerbi/...
For most people, getting started with #PowerBI involves playing with toy dataset in the form of CSV, or EXCEL files. That is a great place to get started. However, in the real world, datasets are often much more complex with intertwining relationships between tables.
The alternative then is to practice with a real world database. However, it is not a good idea to use company database to experiment or learn to use the #PowerBI.
This tutorial walks you through the process of utilising setting up your own local SQL database using SQL Server 2019 Express, with the help of the SQL Server Management Studio (SSMS). In addition, we will show you how to restore a real-world-like backed up database provided by Microsoft to the local SQL server. Once these have been set up, we will connect to the database via Power BI Desktop, after we have downloaded and installed it.