Transforming Nested Tables in Power Query
Most people are aware that Power Query lets you work with tables that have columns containing other “inner” tables. The classic example is a table representing an Excel workbook where
Stay up-to-date with the latest data and AI news, expert guidance, and resources.
Most people are aware that Power Query lets you work with tables that have columns containing other “inner” tables. The classic example is a table representing an Excel workbook where
JavaScript has been a tremendous tool for front-end developers over the past 20 years. And with NodeJS we can leverage this powerful scripting language in new ways and on both
Once again, October brings an amazing opportunity to attend the Portland SQL Saturday event. If you have never attended, you owe it to yourself to check it out. This all
Lately I’ve been working a lot with Power BI using Direct Query. Historically, if my client was considering Direct Query mode, my automatic response was simply “Nope, bad idea”. My
The Problem I recently discovered an interesting issue with Internet Explorer (IE) 11 after taking IE 11 on a date with some cross-browser testing. Some lazy JavaScript code I’d written
While building an ASP.NET Core app, I came across the question of how to override application settings after deploying to Azure. Here I will review how application settings are managed
The addition of the R statistic engine/language to the Power BI platform presents a lot of possibilities for both getting new kinds of data into your model, and displaying information
References Task Async Await Like many developers working with Microsoft’s MVC platform, we have frequently leveraged the trio of C# language features, Task, await and async, to help improve performance
This is a cool trick that goes hand in hand with Relative Month Index. It shows how to include a slicer that lets the user choose which month they want
–VIDEO TRANSCRIPT– In this video I’ll demonstrate how to set default values for function parameters. Some programming languages let you define a function with default parameter values like this: public
If you are looking for a way to spice up your old Web Form application, consider adding the power of Power BI embedded. Today I will show you the specific
This blog post will show you the specific steps needed to add a Power BI Report to a custom web application using the Microsoft Power BI Embedded Service and configure
Industry leaders choose Skypoint as their comprehensive and compliant Modern Data Stack Platform. A Certified Microsoft Solutions Partner, Skypoint Cloud turns siloed data into connected experiences.