Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret. With relational data source like SQL Server you can […]

Read More →

Lors de ma session “SQL Server & Docker, les premiers pas”, une erreur était survenue lors de l’installation manuelle de SQL Server dans un conteneur Windows Server Core démarré en mode interactif. Cette démo relativement simple et sans surprise avait … Lire la suite

Read More →

Samedi 7 juillet se tenait à Paris l’édition 2018 du SQL Saturday. Beau temps, bonne humeur et des speakers passionnés étaient au rendez-vous. Malheureusement, moins de participants qu’à l’accoutumée. Certes il est compliqué de se mobiliser en période estivale, de … Lire la suite

Read More →

It’s very common that you need to combine data from multiple worksheets in the same Excel workbook when you’re using Power BI or Power Query/Get&Transform in Excel. Indeed a lot of people have blogged about how to solve this problem, but none of the solutions I’ve found on the internet work in more complex scenarios […]

Read More →

Following on from my post the other week about the new RowsetSerializationLimit server property, I thought it would be a good idea to write about why the new IsAvailableInMDX property (announced in the same blog post) is so important. In fact, I would say that everyone using Analysis Services Tabular 2017 (CU7 or higher) or […]

Read More →

In the June 2018 release of Power BI Desktop there were a number of improvements made to the way the Power Query engine handles OData data sources. You can read about them here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2018-feature-summary/#oData However, while testing them out, I noticed one important point that the announcement didn’t make: an existing Power Query query will […]

Read More →

The recent blog post on the Analysis Services team blog about new memory options contained information about some very interesting functionality that has just been added. The first of the new features I decided to try was the RowsetSerializationLimit server property, which restricts the number of rows returned by a query and which is intended […]

Read More →

Le SQLSaturday 762 Paris 2018 se profile à l’horizon. L’agenda de la journée est à présent disponible. Mais n’oubliez pas de vous inscrire aux Préconf qui auront lieu de le vendredi 6 juillet. Une journée de formation à prix ultra-compétitif … Lire la suite

Read More →

Voici un petit lien pour télécharger les slides de ma session sur les bases du dépannage dans SQL Server. Encore une fois, merveilleusement accueillis par nos amis Québécois, le SQLSaturday a tenu ses promesses avec une belle affluence et des … Lire la suite

Read More →