Closing out on 2024

It's the holiday season again, already!

This year has been marked by significant advancements in Microsoft Fabric, and Power BI in specific, and I've had the privilege of engaging with these developments both personally and professionally.

Blogging

I can say I haven't been that active on my blog, I always have a lot of plans for the new year, but motivation is still not easy.. 😆 Let's not make plans this year, but just start blogging for myself and not for others or the views, and see what that brings.

5th Year MVP

One of the highlights of the year was being recognized once again as a Microsoft MVP. It’s a privilege to be part of this amazing program, and I’m very grateful for the opportunities it provides, to share knowledge, collaborate with brilliant minds, contribute to the data community and create new friendships.

Microsoft Ignite 2024: A Glimpse into the Future

One of the biggest events this year was Microsoft Ignite 2024, held in Chicago. The conference had some great innovations, with the number one being the introduction of Fabric SQL Database (in preview). This developer-friendly, transactional database, based on Azure SQL Database, offers seamless creation of operational (OLTP) databases within Fabric. Its integration with OneLake ensures near-real-time data replication, bridging the gap between transactional and analytical processing. 

Another noteworthy feature introduced was the Metrics Hub (also in preview), setting a new standard in how organizations define, track, and share KPIs. This centralized management system integrates effortlessly with Power BI, promoting consistency and enhanced collaboration across teams. 

Community Engagements and Speaking Opportunities

This year also provided new opportunities to connect with the data community through various speaking engagements. Events like DataGrillen in Germany and the 1st Fabric Conference in Europe were particularly memorable. Sharing insights on topics such as Administration and Governance in Fabric, and engaging in lively discussions with fellow data enthusiasts, was both fulfilling and inspiring. This extended beyond sessions, with early morning runs and social gatherings strengthening the relationships with old and new friends in the community. 

Looking Ahead

As we are moving into the new year, my agenda is already filled with promising developments. The upcoming Fabric February 2025 event in Oslo, Norway, is an occasion that promises to bring together the best minds in the industry. And in March the MVP Summit in Redmond will be another highlight!
It's an exciting time to be part of the data community, and I look forward to continuing this journey with all of you, exploring new technologies, sharing knowledge, and fostering the collaborative spirit that defines our field. 

Thank you for being a part of this year's journey. Wishing you all a great New Year's Eve and an insightful 2025 ahead!

Nicky. Out.

P.S. I should mention that I did use AI to create a summary of events of my blog and my LinkedIn posts. I used that as a basis for this post.

Data, Insights, and Community: My Reflections on Data Saturday Holland and dataMinds Connect

The Lamot conference center alongside the river Dijle in Mechelen, Belgium

The world of data and analytics is constantly evolving, with new tools, technologies, and best practices emerging almost daily. As a data enthusiast and professional, I'm always on the lookout for opportunities to expand my knowledge and stay up to date with the latest trends in the field. Recently, I had the pleasure of attending two fantastic events: Data Saturday Holland and dataMinds Connect, and you may already guess—it was amazing!

Data Saturday Holland - Where Passion Meets Expertise

Data Saturday Holland, formerly known as SQL Saturday Holland, is a renowned event that brings together data professionals, enthusiasts, and experts to share their knowledge and experiences.

One of the things that struck me the most at Data Saturday Holland was the passion of the speakers and participants. From Power BI to data engineering, there was a wide range of sessions to choose from. I attended sessions covering various topics like Direct Lake in Power BI and improving your Power BI report. These sessions provided me with valuable insights and practical tips that I could immediately apply to my work. It was enlightening to learn from experts who shared their real-world experiences and demonstrated the tools and techniques they use on a daily basis.

A highlight of the Saturday was being able to attend my favorite podcast, Knee-Deep in Tech, live in a movie theater!

Knee-Deep in Tech by Heini Ilmarinen, Alexander Arvidsson and Simon Binder

Another highlight of the event were the networking opportunities. I had the chance to meet old friends and new people, exchange ideas, and even discuss potential collaborations. It's incredible how the event fostered a sense of community and encouraged knowledge sharing. I left Data Saturday Holland inspired and motivated!

DataMinds Connect - A Deep Dive into Data and AI

Just when I thought my week couldn't get any better, I had the privilege of attending dataMinds Connect. This event is an annual conference organized by the dataMinds community, focusing on Microsoft Data Platform technologies. The event spans (for now 😏) two days and covers a wide range of topics related to data and AI.

One of the standout features of dataMinds Connect was the depth and breadth of the sessions. Experts from various domains within data and AI shared their knowledge. From advanced SQL Server features to leading AI applications, there was something for everyone. I especially enjoyed the in-depth sessions that allowed me to explore complex topics in detail, like Mathias Thierbach's Power BI Source Control precon.

I also volunteered during the two days this year, assisting speakers and visitors in making the most of their own experience. During Mathias' workshop, I helped answer questions and on the second day, I addressed general visitor questions and took care of the speakers, so they didn't have to worry about the technical aspects, drinks, or other logistics.

The community at dataMinds Connect was incredibly welcoming, and I had the opportunity to engage in conversations with participants and speakers. This sense of community and feeling of being welcome was a common theme throughout the event, and it's something that truly sets this conference apart. A beer and some chocolate certainly works wonders too! :-)

The Value of Conferences

Attending Data Saturday Holland and dataMinds Connect provided me with a comprehensive overview of the Power BI and Fabric landscape and the latest developments in this field. I left with new skills and insights and a better understanding of the latest trends and technologies. Moreover, the connections I made during these events were invaluable. Networking with professionals who share my passion and interests can lead to future collaborations, career opportunities, or simply the joy of being part of a vibrant and supportive community.

In summary, my week at Data Saturday Holland and dataMinds Connect was an incredible experience! These events not only expanded my knowledge but also allowed me to connect (and continue to connect) with fellow data enthusiasts and experts!

I have a few more things coming up in the following monhts:

• New Stars of Data with my mentee Ioannis Philippides
• Data Left Unattended
• Data Saturday Vienna
• ... A few more things are in the works, but nothing definitive yet...

Do I see you there? 😀

SQLBits 2024 Has Landed!

I've written about SQLBits before here and here, but in case you still don't know what SQLBits is, it's the greatest Data conference in Europe, spanning a whopping 5 days, including the free community event on Saturday.

From the SQLBits website:

SQLBits is the industry’s leading Data Platform conference with over 300 sessions across 5 days covering data technologies including SQL Server, Azure, Big Data, Power BI, Machine Learning, and more.

And if you need a reason (for your boss) to attend SQLBits: there are 10 reasons listed on their website!

Next to all the great content, there's also lot's of extra's happening at SQLBits, like a board game night, a pub quiz, a SQLBits run and last but not least the famous Friday night party!

Previous Editions

I've also had the pleasure of presenting at 2 SQLBits events. In 2022 it was virtual, but last year I was excited to be attending and speaking at my first in-person SQLBits! I delivered 2 sessions, one (20-minute) lightning talk and a general session on Write-back with Power Apps in Power BI (the recording can be found here).

2024

Now on to the 2024 event, last week there was a live stream with Marco Russo, Alberto Ferrari (both from SQLBI) and Simon Sabin (founder of SQLBits) announcing the dates and location for this years event. This year SQLBits will be from March 19th - 23rd, in Farnborough.Hampshire, UK.

The theme for this year will be Aviation, because Farnborough is the birthplace of aviation and the home of pioneering spirit.

The pricing and Call for Speakers for the event will be open very soon, so be sure to keep an eye on their website!

See you there? 😀

Let Me Google That For You

In case you're not familiar, let me first explain what I mean with the title.

Let Me Google That For You is a website, that let's you create a demo of how to do a user-specified Google search. It was designed for tech-savvy people that are frequently asked for help. Its purpose is to gently, but sarcastically, point out that by searching for the problem yourself first, you'd probably come a long way to the answer.

While Google is the brand name of a leading internet search engine company, it's also quite commonly used as a verb:

To search the internet for information about (a person, topic, etc.):We googled the new applicant to check her background.

And of course, there's also a Bing alternative: Let Me Bing That For You.

Or even Let Me DuckDuckGo That For You 😄

How to google

Because once in a while I see people ask questions that I can (easily) google, I thought it might be worth writing down how I like to perform my searches. 
It might be obvious already, but I like to use Google for that. I find it to be better at its job than others, even for Microsoft tech like Power BI and Power Platform.

When searching for information, there are a few things I like to do:

Start with the topic

Start with a 1 or 2 word, preferably as short as possible, topic, like:

• Power BI
• Power Query
• DAX
• (Power BI) REST API
• PowerShell Power BI

Keep it short/to the point

After that, add your question on the topic, but also as short as possible. Try not to add too much filler words like and, or, the and a(n). I also tend to stay away from How do I type of questions.

So instead of asking: how do i use the power bi rest api with an authorization header

I like to keep it short and to the point: power bi rest api authorization header

While the search results might not differ thát much, the most important thing to me is that Google suggests search words for you. That way you will get the most commonly asked questions to choose from. That's particularly usefull when you don't know exactly what you are looking for.
In case of an error message it's often quite clear, but if you're looking for more general things, or for authorization with an API, you might not know it's called a bearer token.

Errors

In my line of job I unfortunately quite often run into errors. I always use the exact error message that I encounter: word for word. If the error is too long I might try the first part/sentence of it. But keep it exactly as it is. But again, I start with a 1 or 2 word topic, followed by the error message.
A good habit was to create a blog post on the topic if I couldn't find a solution easily. Mainly back in the days when I used to work a lot with SSRS and SSDT.

Ask for help

Sometimes you just can't find it on the interwebs. Then your best bet is to ask for help! There's quite a good chance someone has run into that same problem before.
Ask you co-workers, use Twitter, the Power BI Community, Reddit, a private or public Slack group, whatever works for you.

I'm quite active on Twitter (@NickyvV) and have been using that for over a decade. If you are not, I highly recommend to start doing that. Not only for asking for help, but surely also for the amazing community of Power BI and SQL Server people hanging out there.

There are even specific hashtags you can incorporate in your search: #sqlhelp, #powerbihelp, #pbihelp
Those are monitored throughout they day by a bunch of people that want to give others a hand.
And it's still Twitter, so sometimes you come accross some people that are, let's say, a bit less welcoming.. 😃 

The majority of interactions is however positive, it's an amazing community!

Searching for Call for Speakers

Because I'm also active in the speaking community, I sometimes like to search for places where I can submit my talks. In my opinion Sessionize is the best platform to use, for speakers as well as conferences. It quickly let's you make a public speaker profile with presentations you can give, but also submit those presentations to conferences without the need to re-enter all the same details over and over again.

Since a while, the website has this Discover events tab which you can use to search for open call for speakers. Before this option was available, and I still do it sometimes to make sure I'm not missing anything on Sessionize itself, I used the option to search for keywords on a specific site on Google:

site:sessionize.com power bi

Closing

With this write-up, I hope I gave you some insights in my daily routine of getting help with things I run into. And to be clear, me having xx years of experience, having a certain title on LinkedIn or being a Microsoft MVP has nothing to do with my amount of searches or things I have to look up.
Sometimes we like to think we do, but we can't know everything. Also, Power BI (and Power Platform) is constantly changing. I would say I'm probably looking for some sort of help more than 20 times a day, every day!

Quick tip: Sharing Power BI Dataflows

Problem

What rights does a user need to access a Power BI dataflow?

Just a quick post on Power BI dataflows after I saw this question on the Power BI Community forum about sharingdataflows - only via member/contributor permission?.

The user on the forum wants to know how to share dataflows with other users with the least privilege possible.

From my testing, it seems you need to provide people Contributor/Member/Admin to the workspace with the dataflow. If you choose the lowest permission Contributor - then they can't edit the dataflow BUT they can take over ownership and change the scheduling ! Not Good. I just want people to be able to connect to the dataflow.Have I missed anything ?

I thought this was just an easy lmgtfy-question, because there are already a lot of sources on dataflows:

• Matthew Roche (B | @SQLAllFather) wrote extensively about dataflows in Power BI, covering dataflows documentation, a whitepaper, Overview posts and much more.
• Reza Red wrote some good posts on dataflows with the use cases of dataflow being the best in my opinion.

Returning to finding the answer to this question, it turned out it wasn't that easy. There even is an open issue on the documentation on GitHub to add this information to the docs. So I ended up testing it myself.

Solution

To access a PowerBI dataflow you need either

• access to the workspace the dataflow resides in as an Admin, Member or Contributor, or
• Viewer role access to the workspace

Option 1, edit rights to the workspace, might not be desirable for your use case. But we have one other option: the new Viewer role that was introduced back in June of this year can also be used to share dataflows. I already wrote about the new Viewer role in PBI Desktop earlier.

When you are granted Viewer role access to a workspace where a dataflow is created, you can connect to and use that dataflow in Power BI Desktop:

Final thoughts

On a dataset you also have the ability to give the Build permission to give someone access to create content from that dataset (e.g. reports, dashboards, pinned tiles from Q&A, and Insights Discovery, but also content outside Power BI). This feature is still in preview however at the moment of writing. As the documentation says: Build permission is only relevant for datasets, for now? :-)

There is an idea that sounds like the Build permission on dataflows: Dataflow Permissions to give access to an individual dataflow.

Maybe the Build permission will also be added to dataflows in a later phase?