The Issue Recently one of our team members faced the following issue: We have SSAS Tabular model deployed in DirectQuery mode taking data from MSSQL server database. Suddenly SSAS...
2022-04-04
4 reads
Have you ever wondered whether it is possible to restrict installation of the Power BI Gateways (GW) in your tenant? If so, read along… The first question that probably...
2022-04-04
13 reads
Ve středu 9.3.2022 jsme se tradičně sešli nad novinkami ze světa dat, datových skladů, Power BI, Azure apod. Jestli jste chyběli (ale příště dorazíte, že? :D), zde je malý...
2022-03-31
3 reads
V rámci svojho bootcampu (https://joyfulcraftsmen.com/bootcamp/) v Joyful Craftsmen, na ceste stať sa Data Engineerom, som sa často (rozumej takmer vždy) stretol s novými technológiami. Keďže jednou z bežných činnosti...
2022-04-04 (first published: 2022-03-22)
229 reads
The Issue Recently one of our team members faced the following issue: We have SSAS Tabular model deployed in DirectQuery mode taking data from MSSQL server database. Suddenly SSAS...
2022-02-09 (first published: 2022-02-01)
555 reads
Předminulou středu jsme opět poobědvali a zároveň si nasdíleli řadu novinek ze světa dat. Tak doufám, že příště dorazíte i vy! Můžete klidně i jen poslouchat, pokud vás novinky...
2022-01-25
38 reads
8. prosince jsme se opet sešli u obeda nad novinkami ze sveta dat. Je super, že se stále více úcastní i lidé mimo JC – jsme rádi, že se...
2021-12-27 (first published: 2021-12-19)
126 reads
Predminulý týden (10. listopadu 2021) jsme porádali už nekolikátý verejný Tech Lunch. Jde o pulhodinový call, na kterém pravidelne prezentujeme novinky ze sveta dat (datové sklady, Azure, SQL Server,...
2021-11-23
6 reads
Introduction In my last blog post, I have addressed an issue with DAX Median function consuming a lot of memory. To refresh the result, below is the performance summary...
2020-12-10 (first published: 2020-12-01)
219 reads
Introduction Median is a useful statistical function, which first time appeared in SSAS 2016 and in Power BI around that year as well. There are several articles on how...
2020-12-08 (first published: 2020-11-24)
320 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...