Power BI - Service

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 this session, Krish will show you how you can use Power BI to easily create 'real' real-time scenarios using Streaming Dataflows.

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 blog post I show you how to easily use Power BI Embedded and use your own reports to see what it looks like.

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…

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 …

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.

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

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

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…

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…

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.

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.

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.

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" 🤓

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

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.…

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

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

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, […]

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,

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.

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.

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.

Capacity settings for datasets now in Power BI Premium Gen 2!

This series start discusses why Power BI Goals are a great fit for those new to Power BI and what three key decisions are needed.

You can now create reports connected to Power BI datasets from a blank workbook in Excel for the web.

We’re excited to announce enhancements to the export to Excel experience. Read this blog to learn how these changes help more Excel users use data from Power BI to make decisions.

I was shocked, suddenly important reports were missing from my workspace in Power BI service. But thanks to the help of Mellisa Coates, I was able to make