MarkDataGuy
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...
top of page
Search
MarkDataGuy
- Jun 18, 2022
- 3 min
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, 2022
- 1 min
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, 2022
- 6 min
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, 2022
- 1 min
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, 2022
- 2 min
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, 2021
- 1 min
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, 2021
- 1 min
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, 2021
- 3 min
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, 2021
- 1 min
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, 2021
- 4 min
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, 2021
- 4 min
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, 2020
- 5 min
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, 2020
- 2 min
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, 2020
- 2 min
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, 2020
- 4 min
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, 2020
- 2 min
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, 2020
- 2 min
#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, 2020
- 8 min
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, 2020
- 3 min
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