Power BI Tables

An Introduction to Power BI

Introduction Power BI is a collection of software services, apps, and connectors working together. It helps to connect different data sources and get visually immersive and interactive insights from the data. Power BI creates powerful reports to be shared with others, as required. Data may be connected from different sources including files, databases, Azure services, […]

Analyze Azure Cosmos DB data using Synapse Link and Power BI

Introduction In my last article, Using Azure Synapse Link for Azure Cosmos DB , I discussed creating the Synapse Link to query data present in Azure Cosmos DB from my Synapse workspace. Here, I will create a new database in the serverless SQL pool and create views based on the Cosmos DB JSON files. Then, I will […]

Power Query Performance And Expanding Columns

A critique of a first attempt to write an M query to convert a folder full of images to text that caused PowerQuery to perform multiple file reads

Introducing the Power BI Performance Analyzer

This article describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports.

R Script Visual in Power BI

Dave Mason takes us through his journey in learning how to visualize data with R, in Power BI desktop.

Working with time in Power BI Desktop

Need to work with hours and minutes in your Power ...

Power BI Basics of Modeling: Star Schema and How to Build it

Now that you know about the dimension and fact tab...

Power Query Is No Longer DAX’s Little Brother

I’ve talked before about the difference between ...

Storing Large Images In Power BI Datasets

Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html https://blog.gbrueckl.at/base64/ Since they wrote those posts, however,...