Returns a list of the tenant settings. Permissions The user must have administrator rights (such as Office 365 Global Administrator or Fabric Service Administra

This article shows you how to set up a flow on Power Automate for creating a version control system to check all Power BI reports (in your organization) every minute in order to find the reports that have been modified, record those modifications in the Change Log, and export/save them as PBIX files.

Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here: There are code samples here: And guess what, t…

DataOps Principle #16 - Monitor Quality and Performance

In this blog post I'm going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as the programming language because in my opinion it was a bit easier to authenticate with the Power BI service. For the development environment, I'm using

How to configure a service principal in Azure and then use it in Power BI Admin REST API calls in Power Automate for authorization

This blog post shows how to find out which columns are being used the most in visuals and DAX measures in Power BI Premium/PPU

Scenario: As more and more reports are configured to be refreshed, sometimes you may encounter refresh failures. So we need quickly detect whether a dataset refresh has succeeded or not succeed. Based on such a scenario, we can then use PowerShell's related commands to get historical refresh records...

As a developer, how many times have you had a need to test different Microsoft 365 APIs? For me, this is a fairly frequent task. Most often it's SharePoint REST API or MS Graph. Every time you should think about the authentication part because all of... [Click to read more]

Returns a list of artifacts that the given user have access to (Preview). This API allows 200 requests per hour at maximum.

A new Admin API to determine user permissions

I’m happy to update that during September we are modifying the preview release, specifically lifting the 50 exports per hour per capacity limit. More details inside.

#APIS #CATALOG #POWER BI #POWER BI ADMIN API

Public preview announcement of access rights admin APIs

Models utilizing XMLA endpoints will reflect refresh details in the Power BI Service!

We are very excited to announce the public preview of a new REST API to query datasets in Power BI by using Data Analysis Expressions (DAX). Among other things, this new DAX REST API helps to address customer feedback concerning programmatic access to the data in a dataset (for example, the idea REST API access to READ datasets with almost 500 votes by the time of this announcement). The new DAX REST API avoids dependencies on Analysis Services client libraries, requires no connection to XMLA endpoints, and works in Power BI Premium as well as in Power BI shared capacity

We are thrilled to announce that the public preview of streaming dataflows in Power BI is now available for everyone to try out.

When I am working with the Power BI REST APIs I am regular visitor of the API documentation. I always learn a lot about the data when I am building a Power BI report so I thought it would be a useful exercise to create a Power BI version of the API documentation. If you […]

If you’re interested in cascading parameters and Power BI custom connectors is an option for your project, you should give a try to Navigation Tables. Which soon enough could make their way i…

Push data to Power BI dataset, for visualization on realtime dashboards

Today, I am happy to announce an exciting new update to the Power BI connector for Microsoft Flow. Coming hot on the heels of our data alert Flow trigger, we have added a new action which pushes rows of data to a Power BI streaming dataset.

We’re excited to share some new APIs that are now enabled in Power BI and describe how you can use them in your applications. Below, we’ll talk about the new APIs we’ve added to let developers upload content to Power BI programmatically...

Your company’s page on Linkedin is a treasure trove of insightful data. In today’s post I will show you how to import this data to Excel or Power BI Desktop. In my posts here and here, we focused on the companies-search Linkedin API call, which allowed us to extract companies by specific specialties/domains and perform analysis of industry, geolocation …

This week I was working on a project for a school up North. This customer wanted to use Power BI and map visualizations to view the locations of the various school buildings in the district. The pr…