Power BI

Power BI Desktop customers can now visualize data in their Delta Lake using Databricks with just a couple of clicks. In the past, connecting to Databricks from Power BI Desktop required the end user to perform a lot of manual configuration. Power BI Desktop integration with Databricks Partner Connect makes it simple to connect to your Delta Lake so you can start doing analytics and sharing insights with your business.

We are announcing support for user impersonation using the EffectiveUserName connection-string property. This is truly exciting because it opens the door for mass migrations of tabular Analysis Services solutions that rely on EffectiveUserName-based impersonation to Power BI. It also opens new options for administrative tools and scripts to connect to datasets on Power BI Premium using different user identities! Impersonating another user can be as easy as specifying that user’s UPN on the connection string.

Deployment Pipelines within Power BI Service are a strategic feature that allows users to better manage content across the development stages of their organizations. By leveraging this powerful tool, users can simplify the deployment process and ensure security of potentially sensitive data. In this article, we’ll breakdown the specifics of deployment pipelines, and discuss how you can best leverage this tool within your organization for optimal efficiency.

On-premises data gateway (standard and personal mode) release for November 2021

We are thrilled to announce the release of Power BI APIs .NET SDK v4. The new SDK version provides clarity on the properties of Power BI artifacts returned by various APIs and makes it easier to use them,

Not sure what a REST API is? Or what you can do with them in Power BI? Find out how you can easily take advantage of them without having to write a bunch of code. Use PowerShell instead! REST API Reference Documentation https://docs.microsoft.com/rest/api/power-bi/ Power BI PowerShell Reference Documentation https://docs.microsoft.com/powershell/power-bi/overview Use Microsoft Flow, and other options, […]

This blog is a resource to develop an understanding of data analytics and to become more familiar with the industry terms.

We are excited to announce new capabilities for Streaming Dataflows in Power BI.

Power BI Dataflow security is managed at the workspace level, this means when you add the user to the workspace he will be able to see all the Dataflows inside the workspace and every table within.…

In this blog I show how to use PowerShell to automate the processing of multiple Power BI partitions, which is faster.

On Tuesday, March 8th, I will be delivering a training day at SQLBits 2022 called "Beginner's Guide to Data Integration using Azure Data Factory or Azure Synapse Analytics" 🤓

We’re very excited to announce a new way to visualize your model-driven Power Apps and Dynamics 365 data stored within Dataverse. With a single click, Power BI automatically generates a set of visuals for you to explore and find insights within your data. This integration is great way to take advantage of the full power of the Power Platform.

The capability to pass custom data for row level security is now available in Power BI Premium, Power BI Embedded, and Power BI Premium per User.

Asynchronous refresh now available in Power BI for public preview. The asynchronous refresh REST API for Power BI brings built-in features for reliability, such as auto retries and batched commits.

Power BI dataflows (PBI dataflows) is a powerful data prep tool for you to transform data and reuse them in other places downstream. At the same time, while Excel is very popular among business use…

As a Power BI administrator you want to see what’s happening in your tenant right now: who’s running queries, which datasets are refreshing and so on. That way if a user calls you to co…

Describes advanced incremental refresh and real-time data features with the XMLA endpoint.

This month we have released highly-anticipated features for deployment pipelines: Azure DevOps extension, to automate your deployments and pipeline creation using Tasks in your Azure pipeline. Multiple pipelines working together, to sync the connections between items managed in different pipelines. Dataflows GA and support for linked entities

Incremental refresh with non-foldable data sources are not recommended, but if you can retrieve just some period of data, it's possible to do it.

Log Analytics contains information on the dataset, report and visual that are associated with a DAX query but that information is in the form of IDs rather than names. Getting the IDs for specific …

Hybrid table is a Clever technical solution to a very fundamental problem in Data Analytics, How to keep Data fresh and at the same time fast, PowerBI , Tableau, Qlik solved this problem by importi…

In this blog post I show you how to easily use Power BI Embedded and use your own reports to see what it looks like.

It is a quick Hack and maybe useful, let’s say you want to keep a snapshot of a previous data, for example you have a dimension table and you want to see how the data has changed between mult…

In this session, Krish will show you how you can use Power BI to easily create 'real' real-time scenarios using Streaming Dataflows.

What are orphaned Power BI Workspaces and how do you get rid of them? What if you have a lot of them? Adam walks through some options including a PowerShell script! Delete Group/Workspace API: https://docs.microsoft.com/rest/api/power-bi/groups/delete-group AddUserAsAdmin API https://docs.microsoft.com/rest/api/power-bi/admin/groups-add-user-as-admin Power BI PowerShell CMDLETs https://docs.microsoft.com/powershell/power-bi/overview?view=powerbi-ps PowerShell Script: https://github.com/itsnotaboutthecell/PowerBI-cmdlets/blob/master/notebooks/PowerBI_Delete_Orphan_WS.ps1

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow…

OData has been adopted by many software solutions and has been around for many years. Most solutions are using the OData is to serve their transactional processes. But as we know, Power BI is an analytical solution that can fetch hundreds of thousands (or millions) rows of data in a single table. So, obviously, OData … Continue reading Optimising OData Refresh Performance in Power Query for Power BI and Excel

BigQuery team recently released a fantastic new functionality, when using BI engine, all the statistics are saved in the INFORMATION_SCHEMA. When using BI Engine one major pain was it was not very …

Today, we’re happy to announce significant performance improvements to backup and restore operations for datasets in Power BI. Our benchmark tests with 1GB, 5GB, and 10GB datasets show backups can now be completed up to 22 times faster than before, and the time required for restore operations can also be reduced by more than 30%.