Introduction In this article, we will learn to create a Power BI report using MySQL data. The article will teach us to use the MySQL Workbench (something like the SSMS, but for MySQL). We will do the following in this article. First, we will connect and create a database in MySQL. Secondly, we will create a […]
2023-01-09
4,442 reads
In this article, we will learn how to use a REST API from Power BI to get data for a report.
2022-12-16
24,490 reads
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
6,347 reads
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
13,949 reads
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
2022-10-03
14,360 reads
In this fourth part of the series, we look at various other plot types in Power BI using Python.
2022-09-26
1,503 reads
In Part 3, we look at how to use Python to create more charts for Power BI.
2022-09-19
1,698 reads
This article continues looking at python code in Power BI to produce charts.
2022-09-12
6,040 reads
This article will show you how to use a Powerpoint theme to modify and beautify a Power BI report.
2022-08-22
5,189 reads
This article will show how you can code in Python and produce a chart for Power BI.
2022-08-15
14,318 reads
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
A while back I wrote a quick post on setting up key mappings in...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Comments posted to this topic are about the item Creating JSON III
Comments posted to this topic are about the item Testing is Becoming More Important
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers