Friday, September 24, 2021

Back In Business: Power BI Next Step

So, I did a presentation last Friday on Query Folding in Power BI.
It was at the Power BI Next Step conference.
You might think it was another online, like the 2.463.345th, webinar via Teams. But...

WE WERE IN COPENHAGEN!! 😁


Meeting people again, having a chat and drink with other speakers, attendees and #pbifamily friends I haven't seen other then online... It was A-MA-ZING to be back at it! 

Because a few months ago there was still some uncertainty about all the rules, Marc, his girlfriend and me decided to take a road trip and go by car, which was pretty doable and actually quite fun.


I also went for a little run just after the conference!

We also had a lovely speaker dinner in the oldest restaurant in Copenhagen: Det Lille Apotek:


And on Saturday we finished it off with a little boat trip:

 

Slides and more...

The conference will send out all the slides, but if you can't wait for mine, you can find them at my GitHub page, or directly download the slides as PDF here.

During the conference, several people asked if the information from my session was also available on my blog somewhere, which actually is not (yet 😀).

So with renewed energy from the conference, I'm announcing my next topic here:

A blog series on Query Folding!

Keep an eye out for the first part next week!

Wednesday, January 27, 2021

Power Platform 2021 Release Wave 1 Plan

The Power Platform 2021 Release Wave 1 Plan has just been released!


You can go to the plan in the documentation (here) or download the detailed PDF (here).

I'd like to give you a quick summary of what I think are the most exciting features coming up in this wave. Remember though that this plan focusses on the period from April to September 2021, so features releasing before that will not be taken into account here. For example: Object-level security is a feature planned for Public preview in February 2021. For a complete overview have a look at the 2020 release wave 2 plan.

My primary job focus is with Power BI and Power Platform governance, so as you may understand, the majority of features will be in that direction.

I also display the Public Preview (PP) and General Availability (GA) dates here, just to have a complete overview. Please be aware that this is a post on my blog that is accurate at the time of writing. For the most recent status of features please go to the 2021 Release Wave 1 Plan.

A little disclaimer before we start: Because this post lists features that may not have released yet, delivery timelines may change, and projected functionality may not be released. For more information, go to Microsoft policy.


Power BI

For an overview of all Power BI related new and planned features, go here. These are my favorites:

OLS permissions for dataflow entities (PP - | GA May 2021)
This will allow you to give permissions to specific entities inside a dataflow, so you don't have to share the whole dataflow anymore.

View permissions for dataflows (PP May 2021 | GA - )
This allows owners of a dataflow to give view permissions, so users can browse entities in a dataflow. Combined with the previous feature, you can now share a specific entity with view access.

Workspace level refresh for datasets and dataflows (PP May 2021 | GA - )
This is HUGE! This feature will take care of refreshing all artifacts inside a workspace, also taking care of dependencies and orchestration of those refreshes.

Deployment pipelines - dataflows support (PP May 2021 | GA - )
This feature describes itself, although there are 3 sub features mentioned:

  • A way to visually compare the code between 2 versions of a dataflow
  • Deploy dataflows through the stages
  • (!)Maintain the relationship between dataflows and datasets through the pipeline

Background validation for dataflows (PP - | GA April 2021)
When saving a dataflow, the validation will no longer be blocking for the UI and be performed in the background.

Data lineage, impact, and API enhancements (PP April 2021| GA - )
While there are a few capabilities already available (lineage view in the workspace, dataset impact analysis), the below will also be added:

  • Composite models in lineage view
  • Admin API's to scan artifacts and lineage cross tenant
  • An API that returns the list of workspaces that changed since the last API call
  • Extending Service Principal authentication for Power BI read-only API's


Power Automate

For an overview of all Power Automate related new and planned features, go here. These are my favorites:

Improved onboarding experiences for new users (PP March 2021 | GA April 2021)

Improved licensing and usage visibility for Power Automate environments and tenants (PP March 2021 | April 2021)
This visibility will be provided in the Power Platform Admin Center (PPAC) and the flow analytics page.

Admin reports to show API usage for users and flows (PP April 2021 | GA - )
There will be license reports in the PPAC to view the API usage of flows and users, giving admins the capability to determine when flows or users are approaching usage limits.

Governance capabilities to prevent data loss (PP April 2021 | GA - )
There will be more governance capabilities in the PPAC including:

  • Connector restrictions
  • Connector action restrictions
  • Endpoint filtering
  • Restrictions for sharing connections


Governance and administration

For an overview of all governance and administration related new and planned features, go here. These are my favorites:

Power Platform tenant isolation support (PP April 2021 | GA - )
Enable/Disable tenant isolation using self-serve capability through the PPAC. Previously, we had to create a support ticket to enable tenant isolation.

User security configuration experiences in PPAC (PP April 2021 | GA - )
Managability of users and security will be better and centralized in PPAC, with a modern and intuitive UI for environments with a Dataverse database. Also AAD-groups will be included in the security role assignments

Tenant scope admin report for Power Apps usage (PP April 2021 | GA - )
Power Platform service admins will be able to understand usage with metrics like Monthly Active Users (MAU), the kind of engagement with new and return users, and also the list of apps in use and not in use at the tenant.

Tenant-level admin reports for flow usage (PP April 2021 | GA - )
Similar to the previous feature, but now for Power Automate. This will also provide useful insights, primarily in the field over number of (successful and failed) runs, number of makers and also total flows, number of flows created in the last 30 days, etc.


Data Integration

For an overview of all data integration related new and planned features, go here. These are my favorites:

Data source management enhancements (PP - | GA September 2021)
This is a LOOOONG awaited feature, at least from my side! :-) While the PPAC now already shows Power BI gateway data sources in read-only mode, centralizing the management will be enhanced further, a.o. by:

  • visibility of the username and service principals of a data source,
  • a new field called Data source description,
  • Installed date, and Last used date for the gateway,
  • and support to use groups instead of users. 

Email Alerts (PP - | GA September 2021)
For me, the best enhancement here is to set up email alerts to notify for updating to a newer version of the gateway.

Reuse and share queries across Power Query clients with Power Query templates (PP September 2021 | GA - )
While not immediately helpful for me (because I don't work that much with PQ), I do see the great potential for this feature!


Closing

All-in all a great set of features to be working on. I can't wait to get my hands on them!

Next to all this Power Platform goodness, there's also a lot going on in Dynamics 365, if you're interested have a look here.

Let me know what your favorite feature is or if you think I missed anything important!

Thursday, November 12, 2020

My Past & Upcoming Speaking Engagements

I noticed I already did quite some presentations this year (15). So I thought this would be a nice time to give a short update on what I did and what presentations are still to come.

Past Talks

  • Denmark Power BI User Group (webinar), November 4th
  • MVP Lightning Talks (webinar), October 21st
  • DataWeekender #TheSQL (webinar), October 17th
  • SQL Saturday Denmark (webinar), September 26th
  • SQL Saturday Croatia (webinar), September 19th
For a full list of all my presentations have a look at my speaking page.

A while ago I decided to create a github page to host all my slidedecks, so have a look there if you are looking for materials: https://github.com/NickyvVr/talks.

Upcoming Talks

M365 Chicago, November 13th

I know, it's Friday, and it's the 13th: what could go wrong, right? :)
I'm actually delivering 2 presentations here, which you can find below, one at 7PM and one at 10PM (UTC+1).


You can still register for this event here.
Just be aware that this is a US-based event, so it starts at 3:10 PM (CET) with the keynote: Building Community Through Storytelling and ends with an EndNote Panel at midnight my time.




Power Platform French Summit, November 20th

This will actually be a 2-day event:

  • Thursday, November 19th with a Business Day
  • Friday, November 20th with a Technical Day
Here I'll also be giving my Forms, Flow, Power BI session at Friday afternoon.

Closing

I would also like to mention that the next event (register here) for our Power BI Days Netherlands is scheduled on November 24th with this great line-up:

  • Alexander Arvidsson (b | @arcticdba): The Untruthful Art – Five Ways of Misrepresenting Data
  • Meagan Longoria (b | @MMarie): What Is Inclusive Report Design and Why Should You Care?


Finally, if you are interested in having me talk for your User Group or conference, have a look at my available sessions and let me know here or on Twitter.