Combine multiple tables with UNION / UNION ALL in SQL Server, APPEND in Power Query or UNION in DAX

October 2, 2020
Denis Selimovic
DAX, Microsoft, Power BI, Power Query / M, SQL Servercomment 3Created with Sketch Beta.0 comments

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…

Read more

Load files with changing names from folders with changing names into Power Query

September 28, 2020
Denis Selimovic
Power Query / Mcomment 3Created with Sketch Beta.0 comments

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 -…

Read more

Announcement: Power BI Premium per user coming soon

September 23, 2020
Denis Selimovic
Other, Power BI Premiumcomment 3Created with Sketch Beta.0 comments

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…

Read more

Register now, Microsoft Ignite 2020 takes place virtually and free of charge

September 21, 2020
Denis Selimovic
Othercomment 3Created with Sketch Beta.0 comments

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…

Read more

Dynamic scaling of a measure in Power BI with DAX

September 18, 2020
Denis Selimovic
DAXcomment 3Created with Sketch Beta.2 comments

Automatic scaling of metrics or measures is possible in Power BI for just about any visual. However, there is currently no possibility to dynamically adjust tables or the matrix. With this selection the values can be displayed in millions, for example. Even if the values are restricted due to a slicer, filter or drill down,…

Read more