top of page
Search
MarkDataGuy
Oct 28, 20225 min read
Integrating PowerBI Power Query with the Google Geolocation API.
Hi Everyone, I am currently working on a project that will be turned into a blog/user group talk at some point, more on that at a later...
MarkDataGuy
Jun 18, 20223 min read
Automatically document your PowerBI Models with Model Documenter
Hi There, UPDATE - I have now produced a video about this process, so if you prefer to watch, head over to YT to check it out. Recently...
MarkDataGuy
May 5, 20221 min read
Sessionize, uploading Slides and access speaker cards
Hi There, Sessionize has become a very common service in the Data community world for managing events call for speakers. It does a great...
MarkDataGuy
Mar 6, 20226 min read
Speaking at SQLBits about Bots in Teams - Power Virtual Agents in Teams
Hi There, SQLBits is back in person, and after two years of Covid restrictions, it is great to see in-person events starting up again. I...
MarkDataGuy
Mar 4, 20221 min read
DataFlows belong to a different PowerBI tenant than the one I am signed into
Hi There, This is a slightly unusual issue, as to start with, you have to have to be a member of at least two different PowerBI tenents...
MarkDataGuy
Jan 28, 20222 min read
Planting trees with the HTTP Connector in Power Automate and tree-nation
Hi There, As some of you know, I am one of the organizers of #DataWeekender and a few days ago, we decided that as a thank you to the...
MarkDataGuy
Oct 12, 20211 min read
The case of the different date formats for PowerBI users in browsers.
Hi All, A client of mine approached me today with their latest head-scratcher. In a PowerBI solution of theirs, they wanted the Date...
MarkDataGuy
May 24, 20211 min read
Tabular - PowerQuery - 5 arguments were passed to a function which expects between 2 and 4
Hi There, This is a quick and easy one, related to differences in PowerQuery between PowerBI and when you create a Tabular Model in...
MarkDataGuy
Mar 28, 20213 min read
Working with Power Virtual Agents for Teams
Hi there, I recently discovered that Power Virtual Agents is available as part of your Teams licence. This immediately captured my...
MarkDataGuy
Feb 20, 20211 min read
How to find my Raspberry PI on my network!
Hi All, Disclaimer, this blog post is mostly written so that I can reference it again. It is a bit out of the left field and not my core...
MarkDataGuy
Feb 8, 20214 min read
Power BI - App Source Visuals - Review 1 - Box and Whisker
Hi There, Welcome to my first of what I hope will become many reviews of visuals that are available in App Source. As we know, PowerBI...
MarkDataGuy
Jan 28, 20214 min read
Box and Whisker (boxplot) in PowerBI
The Box and Whisker chart is becoming one of my favorite visualizations to use in PowerBI. It conveys a lot of information in a compact...
MarkDataGuy
Dec 18, 20205 min read
PASS is dead. Thoughts on running a user group without PASS
So last night the #sqlfamily / MS Data community found out that PASS is to officially close its doors from the 15th Jan 2021. While the...
MarkDataGuy
Nov 29, 20202 min read
Import perfmon data to PowerBI with relog
Recently for a client, there was a need to start capturing some basic server performance stats and combine them with user report...
MarkDataGuy
Oct 21, 20202 min read
Consolidating Multiple PowerQuery connections to a single connection
I encountered this issue when working on a PowerBI file where different areas of a data lake were getting imported into PowerBI via...
MarkDataGuy
Sep 28, 20204 min read
Using PowerQuery to recursively extract data from AD
Hello, One of the many objects that you can connect to with Power Query is Active Directory. This is very useful, especially as Active...
MarkDataGuy
Jul 31, 20202 min read
IoT Adventures - Part 1 - Azure IoT Dev Kit
Hi, IoT, billions of devices connected to the internet, all sending and receiving messages, and hopefully doing something useful in the...
MarkDataGuy
Jul 29, 20202 min read
#Brexit on Twitter
Hi All, As a side effect of my "Reboot your Analytics" user group talk, I have been building up a data set of tweets with #Brexit in...
MarkDataGuy
Jun 28, 20208 min read
Rebooting your Data Strategy - User Group Talk Companion
Hello, I have a technical talk called "Rebooting your data strategy with the PowerPlatform and Microsoft 365", which I have presented a...
MarkDataGuy
Jun 6, 20203 min read
Creating Visio Visuals in PowerBI - Lightning Talk Companion Blog
A recent lightning talk of mine was a demonstration of how you can embed a Visio diagram into PowerBI and get it to interact just like...
bottom of page