Power BI

Today, we are excited to announce the public preview of Multiple Audiences in the Power BI Apps, one of the highly requested features from the community. With multiple audiences for an App, now Power BI App author can create multiple audience groups within the same App and assign different permissions to each group.

StrataScratch is a data science interview platform that has over 1000+ real interview questions from top tech companies like Facebook, Amazon, Google, and more.

Microsoft Power BI is a business analytics tool which allows users to gain insight from their data. You can easily create an interactive dashboard by just dragging and dropping data columns into the visualization plane. In this article, I'll show you how to use Python to help you leverage

Connecting Power BI to Microsoft GraphYou are almost near to achieve your goal of becoming Microsoft Power Platform expert. Till now we expect that you have read all the previous blogs and this is our fifth blog. Let have a top-level view of previous blogs.Revision:In first blog we have learned the b

The Ultimate EPL Fantasy Football Report!

In this post I will go over a topic that is frequently asked about and that is using a Service Principal account with Power BI when connecting to data sources. Currently today none of the built-in …

Using the new Power BI Audiences with AAD Security Groups for easier management of reports/dashboards for users.

We are very pleased to announce the introduction of AAD-based filtration to the Power BI Datamarts tenant setting.

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing a Power BI dataset. The flow referenced an Excel file with the in…

We’re thrilled to announce that a new component for embedding Power BI content in Vue.js applications is now available! Vue is an increasingly popular JavaScript framework for building front-end user interfaces and websites.

In the last post I went over using Power Automate to perform a data driven report subscription using a Paginated report referencing an AAS database. The flow referenced an Excel file with the infor…

Hear about the latest updates to Datamart in Power BI since the //Build announcement

Using Azure Blob Storage learn how to quickly pre-load data into production data models.

Explore a few proven strategies for setting up workspaces for your Power BI Premium Per Capacity (PPC) in this insightful blog. Read today!

Our new cross-tenant dataset sharing capability is now available in public preview! This exciting capability allows customers to share their Power BI datasets with external users (consumers) in a way that allows these external users to access the datasets in their own Power BI tenant.

Learn how to enable service principal authentication to permit use of read-only admin APIs.

Power BI REST API custom functions. Contribute to tirnovar/Power_BI_REST_API_PQ development by creating an account on GitHub.

This is a quick tutorial on how to analyse M-functions step-by-step. Invoking a function will only get the results - see how to follow every single step.

Easy way to expand a complex JSON record without loosing the information that is visible already. Works for star schema and for big flat table

In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address What I did forget to elaborate on and what really makes Power BI even more powerfu…

In Excel Power Query, I have a table. Column A has single numbers. I want to mark those records where the Column A value matches a list. A cutdown version of the problem is: let TableA = Ta...

Automatically transform all columns to the types that have been detected in the cells of its first row: Table.TransformColumnTypesToFirstRowsTypes

Over the last couple of years, I have been actively involved in doing Power BI trainings for my clients. Because of that, I am always looking for new and easier ways to explain Power BI concepts to…

Power Query is a very powerful tool. It has a rich interface from which users can easily clean and reshape their data.   Table.Unpivot is one of my favourite feature. It IS a real game changer for cleaning data because business users tend to "build their data in the format that a PivotTable produces...

Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.

How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue.  I thought it might be a good idea … Continue reading →