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,456 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,545 reads
Learn how you can use PostgreSQL data in a Power BI report.
2022-11-14
6,350 reads
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
13,990 reads
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
2022-10-03
14,369 reads
In this fourth part of the series, we look at various other plot types in Power BI using Python.
2022-09-26
1,510 reads
In Part 3, we look at how to use Python to create more charts for Power BI.
2022-09-19
1,699 reads
This article continues looking at python code in Power BI to produce charts.
2022-09-12
6,042 reads
This article will show you how to use a Powerpoint theme to modify and beautify a Power BI report.
2022-08-22
5,193 reads
This article will show how you can code in Python and produce a chart for Power BI.
2022-08-15
14,322 reads
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers