My frequently used Power BI snippets
In my first blog post, I briefly mentioned that my digital notebook – in the form of OneNote – is well filled with plenty of notes and approaches that I want to share here on the blog. One category is DAX and M code snippets, which I use regularly. For example, creating a date or…
Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX
If you want to combine several tables, you have to ask yourself whether you should do this already in the data source such as SQL Server, in the processing of the data (ETL) in Power Query or in Power BI and, above all, where exactly there is a difference. First of all, the post is…
Load files with changing names from folders with changing names into Power Query
What at first sounds complicated and not very useful, can be found in reality from time to time. Recently the automated export of source data from another program in CSV format confronted me with this task. Daily folder for automated export Unfortunately, when exporting from the source system – apart from the target directory -…
Announcement: Power BI Premium per user coming soon
In yesterday’s poston the Power BI Blog, Microsoft announced the upcoming Power BI Premium for individual users. The advantages of Power BI Premium compared to a normal Pro Account are quite clear: 48 refreshes per data set per day compared to 8 refreshes with the Pro License, automated machine learning possibilities, cognitive services, the up…
Register now, Microsoft Ignite 2020 takes place virtually and free of charge
In times of Corona we have to take other ways to avoid the gathering of larger crowds.Such as Microsoft, which is setting this year’s Ignite from 22-24.09.2020 as an exclusively virtual event. For Europeans maybe not even the worst decision 😉 You can register on the Ignite website:https://myignite.microsoft.com According to the PBI blog the following…