service

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

Now that we have introduced the technology in the previous blog post, Introduction to Power BI Dataflows, this post will cover topics about the authoring experience, some important considerations, basic architecture, and Do’s and Dont’s.

When users click Analyze in Excel in the Power BI service, the generated Excel workbook is automatically saved to OneDrive for Business and the workbook can be directly opened in a web browser using Excel for the web.

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintaine…

This blog post shows the users all the Power BI reports they have got access to, and details the steps in Power BI Desktop.

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

Shared Datasets have been around for quite a while now. In June 2019, Microsoft announced a new feature called Shared and Certified Datasets with the mindset of supporting enterprise-grade BI within the Power BI ecosystem. In essence, the shared dataset feature allows organisations to have a single source of truth across the organisation serving many … Continue reading Thin Reports, What Are They, Why Should I Care and How Can I Create Them?

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

We continue to iteratively improve experiences that help you find relevant content and return to your work in the Power BI service. Upon hearing your feedback, conducting usability tests, and running …

DESCRIPTION 📄 Do you have a lot of reports but are still searching for answers ? Do you really know what you are working toward? If so, we need to talk about Power BI Goals and how they can transform how you approach the question , where are we? GUEST BIO 👤 Treb Gatte is a bus

new data source and gateway management experience in Power BI

In this folder, you will find the source code for the PowerBI app report on Dynamics 365 Business Central telemetry in Azure Application Insights.Note that the app is still being testing in a beta …

TL;DR : When using SQL Queries against Dataverse, add the ‘[EnableFolding=true]’ option in Power Query to ensure queries are 'folding' back to the Dataverse service to gain dramatically improved …

Really cool updates for #MonkeyTools for #Excel by Ken Puls from Skillwave Training . This is a “must have” tool for everyone using Excel on Daily basis...