I wasn’t originally planning on including an article on Incremental Aggs as part of this series, but I like the idea, and it seems like a good fit for the series, so here goes. The series so …
Power BI Evolves with More Enterprise-Class Features
At Ignite 2019, Microsoft outlined its vision to continue extending Power BI’s enterprise capabilities. Even with Power BI Premium, deploying Power BI in an organization often means working around concerns such as model size limitations, vague deployment procedures, and more.
Earlier this year I published a few posts describing approaches for retrieving Power BI artifacts via PowerShell scripts. As a Power BI administrator, the scheduled retrieval of this data could bec…
Analysis Services vs Power BI Premium Model Feature Matrix
Over two years ago I published a blog and document with a feature matrix comparing modeling features of the different releases of Analysis Services Tabular and Multidimensional. At that time, the T…
Find all queries to Azure AS from a Power BI report or dataset
I recently found out the SSAS team added new trace information to Azure Log analytics. The new information allows you to find out the report and dataset in Power BI...
Adopting the Microsoft Power Platform in the enterprise
This session introduces the Power Platform Adoption Framework and gives an overview of its start-to-finish approach to help you and your organization get the most value out of any form of Power Platform available to you today. We also share how other enterprise organizations have scaled with large a
One of the best ways to create a quality and immersive user experience in Power BI is to build in interactive navigation. I originally started building navigation into my reports when the tabs were…
While the addition of +/- to matrix row headers has made navigating matrices much easier, end users will often struggle with discoverability or navigating within the levels. After watching a user D…
How Much Data Can a Power BI Administrator Access?
I wrote about (and updated) this topic previously , but this is so important that it warrants revisiting. So let's have a quick chat about what privileges a Power BI administrator has with respect to accessing data throughout the Power BI tenant. All metadata throughout the tenant is available
Updated Version of the Power BI End-to-End Diagram
Updated Diagram An updated version of the Power BI End-to-End diagram is now available! Head on over to the Diagrams page where the latest version will always be. Change Log There’s also a new change log which should be particularly helpful for those of you who utilize this diagram in your P
Heads up: Soon you’ll be able to upgrade your classic workspaces to the new workspace experience 
Soon you’ll be able to upgrade classic workspace to the new workspace experience. This post gives you resources to learn about the upgrade before it becomes available to your users and to be prepared.
Easily search, drag and drop from the new canvas insert pane
To support the scalability of more numerous and powerful components, we are happy to introduce the insert pane. The insert pane is the new way to add components to your app. You can also drag your components into the canvas from the insert pane.
At Ignite we announced the new UI flows feature, but there were a few other updates in the month of October that we would like to share. Use the new child flow feature to have one flow easy trigger another one. The Flow mobile app can trigger flows when you enter or exit a location. We also have twenty-eight new connectors now available, along with many new actions in the most-used connectors!
Microsoft Ignite 2019 Session Recap: Microsoft Power Apps
Last week at Microsoft Ignite in Orlando, we announced many new features, and even a new name: Microsoft Power Apps. Each session had its recording posted shortly afterwards for those who missed it or for those tuning in at home. The entire catalog of videos is now available for viewing on demand. Here is a reference list of the sessions most relevant to Microsoft Power Apps. Included are also a few select sessions related to Microsoft Power Automate and many that are general to Microsoft Power Platform overall.
The ribbon in Power BI Desktop has an updated and modern experience. When you turn on the “Updated ribbon” preview feature, you will see a ribbon that looks more like the ribbon in Office products. In the updated ribbon, you have access to all the existing features that you know and love, and over time, more features will be added to the ribbon.
Analyze LinkedIn Sales Navigator usage data in Power BI
The LinkedIn Sales Navigator Analytics Integration allows teams to seamlessly view and analyze Sales Navigator usage data within Power BI to increase sales effectiveness and maximize productivity.
The November update has major updates in several areas of Power BI Desktop. There’s a new, modern ribbon that aligns Power BI Desktop with Office and adds more functionality. We’re also adding a new visual, the decomposition tree, which is one of the most requested ideas on ideas.powerbi.com. AI functions integrated into Power Query allows you to take your data transformations to the next level, and of course we have incremental improvements across the entire product.
End to End Enterprise Automation with Power Automate UI flows
This week we announced the new UI flows feature – which makes it possible for the first time to use Power Automate to automate applications that don’t have any APIs or connectors. Learn about what types of applications UI flows support, and how to integrate with your existing flows, and more!
Over the past few weeks we have released several new features in Dataflows, allowing users to seamlessly ingest and prepare data that can be widely reused by other users across the Power Platform including lots of new Data Connectors, Data Transformations and other Power Query Online authoring enhancements.
Microsoft Ignite has always announced many new products and new product features, and this year was no exception. Many exciting announcements, and below I list the major data platform related annou…
Dataflow: use of M function turns workspace into Premium capacity?
I'm trying to recreate in dataflows some PQ processes I have in Excel and Power BI, and am suprised by the fact using an M function (e.g. a call to a REST API) is bringing up a reference to "computed entities", which are limited to Power BI Premium. The same function can be called and refreshed on...
In this first post in a series called “Next Level Power BI”, I demonstrate how to create dynamic databars using a Scalable Vector Graphic. A dynamic SVG databar, icon, sparkline or prac…
Inspired in Python Community site eyJrIjoiZDhjM2M2ZjctYzNjZi00OWIwLWI5YWEtYjAxOWIwZTk2YzM0IiwidCI6IjI0YTdhMGYwLTI4ZDgtNDkxNy1iZGEyLTNiMDQ3MTIyMjViMyIsImMiOjR9