Summary
Looking back at this chapter, we started off by looking at the differences between the Excel and Power BI languages and how concatenation is similar but uses different languages. The ampersand operator (&
) was used to show how we can join different strings, dates, and objects before examining how this was different, but similar, to using Text.From
and Text.Combine
.
The setting up of a SQL server is a bit technical and normally, a technician would set this up in a medium to large corporation, although this is changing in the current climate with the use of scalable online platforms that allow you to purchase only what you require, which makes this more affordable for smaller organizations. My advice when installing is to make sure you concentrate on the different steps, as if you change a setting such as the authentication, you might not be able to access your databases.
Lastly, we investigated parameters. We took an intensive look at setting up parameters and accessing...