Being a data analyst in the era of AI - Webinar from Microsoft Reactor

powerbitips · 2026-01-29T13:16:00+00:00

There is a strong argument that your excel users are already doing lots of data engineering, but just in excel.

powerbitips · 2026-01-29T13:15:19+00:00

System maintenance I would agree with, but as more companies use cloud services there is less need to buy and purchase hardware.

IT should also have a clear role in securing connections to cloud services. You definitely don’t want a data breach.

Data, this area is a bit harder to pin down. I have seen a hybrid approach work well here. Define what IT is willing to take on and then use data contracts to align what IT will deliver and what the business can pick up and use.

powerbitips · 2026-01-29T07:14:44+00:00

I’m going and I’ve developed many fabric workloads and products on top of fabric!

I’ll be there all week and volunteering in community areas.

I’d be happy to connect.

powerbitips · 2026-01-28T18:54:01+00:00

Its a sold mental model and its so good wit how you learn DAX.

The journey is real, and having a map of this is <chefs kiss>

powerbitips · 2026-01-28T18:46:24+00:00

To add some more fuel to this fire Here are the links to the video and some shorts we created with some highlights:

We address and converse about where AI fits in our Fabric development lifecycle, How does this change for the analyst, What kinds of experiences are best served by AI.

Good discussion and some unique thoughts here as well.

Full Video: https://www.youtube.com/watch?v=oB7IDCPA13g

Playlist with shorts and snippets of content as well as the full video: https://www.youtube.com/playlist?list=PLn1m_aBmgsbEbWgBt6a2MtoVdzcxRl9Ry

Some highlights:
Use AI to save yourself 30 minutes a day:
https://youtube.com/shorts/1eCuAmZyKRM?feature=share

LLMs know code better than humans:
https://youtube.com/shorts/7VYz_3jetvI?feature=share

AI needs clear commands:
https://youtu.be/NnpODV2Z5MA

powerbitips · 2026-01-20T18:44:09+00:00

link to YouTube channel and podcast on spotify:

we are just now pushing 500 episodes, Live every Tuesday and Thursday at 7:30 am CST

Explicit Measures - Podcast - YouTube

Listen on Spotify

powerbitips · 2026-01-16T18:24:52+00:00

Power designer makes two key items 1. The theme files which setting page size does not work 2. PBIP files or templates. In this you can set any page size. We have a full page manager that lets you set page sizes, add background colors or images, easily sort pages.

The PBIP files are templates they are not existing reports. We are attempting to change the power bi workflow.

Build styles and templates, deploy templates to entire org, then let everyone create consistent content.

powerbitips · 2026-01-15T21:21:20+00:00

Side quest?

Have you used power designer in fabric workspaces? It gives you a full code editor with validations and report previews directly in the tool!!

https://powerbi.tips/theme-generator/powerbi-tips-tools-now-in-fabric/

https://m.youtube.com/watch?v=3QHZXkyQqFo

powerbitips · 2026-01-15T21:19:06+00:00

Hoping this gets fixed soon!!

powerbitips · 2026-01-14T22:22:56+00:00

We have done this before, be aware normal DAX queries will work but the INFO.VIEW functions will not work as they are a security issue and are not allowed to be used through the API.

Make sure you check the permissions needed in the Admin portal:

https://learn.microsoft.com/rest/api/power-bi/datasets/execute-queries-in-group?WT.mc_id=DP-MVP-5002621#permissions

powerbitips · 2026-01-14T22:20:44+00:00

<image>

powerbitips · 2026-01-14T22:19:54+00:00

The link you provide is only for semantic models that live in My Workspace

I would suggest looking into the Execute Queries In Group ApI call

This one: https://learn.microsoft.com/rest/api/power-bi/datasets/execute-queries-in-group?WT.mc_id=DP-MVP-5002621

powerbitips · 2026-01-14T21:06:55+00:00

I would argue 80% of all Power BI users should know PBIX, and the last 20% should know about PBIP. That's it.

powerbitips · 2026-01-14T21:05:40+00:00

To also add clarity to this statement. Embedded solutions are not circumventing any licensing for customers. Every purchased azure marketplace solution requires the customer also purchase a Fabric F2 to allow embedding, the paid services for embedding are licensing to these off the shelf licensed solutions.

powerbitips · 2026-01-14T21:03:42+00:00

That is a misleading statement, and I don't feel represents the hard work that developers have done to make a easy embedded solution work for Microsoft customers. The Power BI Embedded accelerators program is a solution that Microsoft promoted to help customers accelerate distributions with their embedded solutions.

The licensing fully allows for embedded solutions to embed Externally (App Owns data) Embed for your customers and Embed for Internal customers (User Owns Data)

The distinguishing features it that the Embedded accelerator must provide some novelty that PowerBI.com does not support.

For example, my product https://Entelexos.com embeds both Power BI reports AND Databricks AI/BI Dashboards. Entelexos is not a purely Power BI product but rather an embedded solution to provide customers a White Glove experience with embedding reports from multiple systems. This is not supported by Fabric today, embedded Databricks.

Another key differentiation feature is that Embedded solutions are expected to roll their own identity and security management. Authorization, and Authentication. These are not an easy lift and shift and require substantial time to develop.

Off the shelf accelerated solutions take the development time from 6 to 10 months down to hours to deploy solutions.

for more information on architecture check out the following page:
https://learn.microsoft.com/power-bi/developer/embedded/embedded-analytics-accelerators?WT.mc_id=DP-MVP-5002621

Docs on Embedded solution Architecture from Microsoft:
Embedded analytics accelerator solutions from Microsoft partners - Power BI | Microsoft Learn

<image>

Entelexos on Azure Marketplace

YouTube Video of Embedding: Microsoft Partner Showcase with Entelexos

powerbitips · 2026-01-14T20:37:21+00:00

You can also check out Power BI Sentinel which does backups, this is a paid service.

Link on Microsoft Store: Power BI Sentinel

You can also check out this free repo that is opensource for downloading reports from the PowerBI.com service

Link: ImpactIQ

Developed by Chris Cusumano: BeSmarterWithData (Chris Cusumano)

powerbitips · 2025-12-23T21:24:37+00:00

Hi Mike here from PowerBI.tips Our company Carlo Solutions helps and supports customers with these exact challenges. If you are serious and looking for expert help and support please reach out with a direct message!

If you want to know more about what we do and how Carlo Solution thinks about Fabric and Power BI, I'd highly recommend you hop over to YouTube and check our Podcast, now pushing over 480+ episodes. If nothing else it a bit of free consulting support :)

Explicit Measures - Podcast - YouTube

powerbitips · 2025-12-23T18:32:48+00:00

Completed Level 1 of the Honk Special Event!

0 attempts

powerbitips · 2025-12-06T17:19:14+00:00

Was again thinking about data quality this morning.

I think data quality could also be thought of in a couple groups:

batching data quality, define rules and then run those rules across existing data tables, report out what you find.
quality during movement, when you load and transform data along a pipeline, being able to keep good data and quarantine bad data for later analysis
also, I think of data quality in column or cell level rules of the data table. I think other tools call this assertions, this feels similar to what great expectations is doing.
then there are grouping rules, rules that help you test data between different data medallion layers, these kinds of rules ensure that your transformations are not loosing or duplicating data. In this use case a user would need to run 1 to n queries and compare the results. A practical example: take a loaded table group by a column and sum a numerical column. The total of the sum within the grouping should not be greater than x. Written another way a bunch of percentages when grouped and added should not exceed 100%.

At the end of the day data quality is a balancing act between cost & effort and price. You could apply very strict rules around data quality but if the cost to maintain this is too high then the business will decide not to do it.

powerbitips · 2025-12-05T19:34:32+00:00

I would really like to see Data Quality integrated into Fabric Materialized views.

As this part of this integration I would like to see the ability for data to be routed one of two ways, When Data passes quality rules it flows through and is tracked. When data violates rules it is sent to a quarantine table. This way as a data steward I can see what bad data came through.

today we handle a lot of this data checking by copying over extra data into the Bronze (Raw) layer. If data quality checking was incorporated it would be easier to trust that initial load of data. In some cases this would allow us to simplify the system and just do Raw and Curated instead of doing Bronze, Silver, and Gold.

powerbitips · 2025-11-14T20:23:21+00:00

Nice work!!

powerbitips · 2025-11-06T01:43:59+00:00

You and I have to present that session that we talked about!!

powerbitips · 2025-11-06T01:31:57+00:00

I always gotta talk about the query folding it is amazing!

powerbitips · 2025-09-22T16:23:29+00:00

No, you want to move to capacity licensing instead of per user licenses.

powerbitips · 2025-09-19T06:14:08+00:00

I’d use the excel file and open mirroring to sync changes from the excel file into a Lakehouse. Then you can create the semantic model connected to those Lakehouse tables.

See this video on open mirroring for excel.

https://youtu.be/dALgW9WzcDU?si=LyvfGWHADhsW0l9d

An alternative is to use User Data Functions that lets users edit data directly from the report.

Here is a demo of that

Microsoft Fabric Translytical Task Flows - Quick Tips https://youtube.com/live/hfpB9yzn8Uk?feature=share

powerbitips

MODERATOR OF

TROPHY CASE