This is still one of the most common dataflows questions: what’s the difference between Power BI dataflows and Power BI datasets? For the last year I have resisted tackling this question head…
In a recent post I mentioned an approach for working around the import-only nature of Power BI dataflows as a data source in Power BI Desktop, and in an older post I shared information about the en…
Announcing Automated Machine learning in Power BI general availability
We’re happy to announce that Auto ML in Power BI is generally available in all public cloud regions where Power BI Premium and Embedded is available. Using Auto ML in Power BI, business analysts can build ML models to solve business problems that once required data scientists.
Overview of Available AI and ML capabilities in Power BI
There are always many questions about a cheat sheet to shows the existing capability for doing AI and ML in Power BI service and Desktop. In the above chart, I have summarized the capability of doing AI and ML in Power Service and Desktop for each role. I have identified three main roles in…
Use microsoft flow and other options to refresh your power bi dataset
Adam looks at your refresh options for Power BI datasets. Including Microsoft Flow! https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
I use this diagram a lot[1]: This diagram neatly summarizes a canonical use case for Power BI dataflows, with source data being ingested and processed as part of an end-to-end BI application. It sh…
Power BIte: Creating dataflows with Power Query Online
This week’s Power BIte is the first in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by defini…
The Microsoft Power BI team have released a preview Data Lineage feature and I couldn’t be happier! The Power BI lineage view displays the lineage relationships between all the artifacts in a…
[Python] Using the Power BI API Without “Grant Permission” From Admin
La Data Web will show a bit of Python code in order to connect our work with the Power BI Service API. This post will help us to obtain the access token with pure urllib Python 3.7 code. What is special in this post is that we will use the Power BI API without the “grant permission” of the Azure/Off...
Choosing Azure Analysis Services for large datasets - SQLBI
I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations,
If you haven’t seen the news, the Power Platform has a new member of the family: Power Virtual Agents! Power Virtual Agents, provide exceptional support to customers and employees with AI-dri…
Power BIte: Creating dataflows with linked and computed entities
This week’s Power BIte is the second in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by defin…
Announcing new data protection capabilities in Power BI
We are excited to announce new data protection capabilities in Power BI that build on Microsoft’s strengths in security and enable customers to empower every user with Power BI and better protect their data no matter how or where it is accessed. Classify and label sensitive Power BI data using the familiar Microsoft Information Protection sensitivity labels used in Office. Enforce governance policies even when Power BI content is exported to Excel, PowerPoint, or PDF, to help ensure data is protected even when it leaves Power BI. Monitor and protect user activity on sensitive data in real t...
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.
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.
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...
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…
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…
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.
Did you know you can throttle the CPU and Memory on the Power BI On-Premise Data Gateways?
In this blog post below, I am going to show you how to configure the Load Balancing with CPU and Memory. I always recommend for On-Premise Data Gateway installations that there be at least 2 Gateways installed. The initial reason was to ensure that if...
At this point I’ve said “Power BI dataflows enable reuse” enough times that I feel like a broken record[1]. What does this phrase actually mean, and how can you take advantage of …
Announcing: Upgrade your classic workspaces to the new workspace experience public preview is rolling out
We’ve started to roll-out the capability upgrade classic workspace to the new workspace experience as a Public Preview. This post gives you resources to learn about the upgrade before it becomes available to your users and to be prepared. It also answers questions from our pre-release blog and documentation.
Power BI Premium Dedicated Capacity Load Assessment Tool on GitHub
Last month[1] at the Microsoft Business Applications Summit (MBAS), Power BI program managers David Magar and Swati Gupta showed off a new load assessment tool for Power BI Premium capacity workloa…
Power BIte: Creating dataflows by importing model.json
This week’s Power BIte is the third in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach. When creating a dataflow by import…