Jeff Pries

SQL Server, Power BI, and other Business Intelligence and data technologies

Tag: PowerShell

Adding a Non-Email Enabled Object to Power BI Gateway Cluster Users

November 25, 2021 /

The Power BI On-premise Enterprise Gateway allows for users to be added as administrators of the gateway cluster via the Powerbi.com portal.

One annoying quirk about this, however, is that at least as of this writing, it is impossible to add users (or groups) which do not have an email address via the user interface.

Attempting to do so will give the error message “These email addresses are invalid or duplicate.” Pretty annoying!

It turns out that it is actually possible to add objects which do not have email addresses associated with them (groups, users, even application SPNs), however it must be done with PowerShell.

Continue reading

Getting Started with the Power BI API – Querying Power BI with PowerShell

September 27, 2019 /

Recently, I was using the Power BI Service at powerbi.com and I had a few questions that I wanted to answer for myself about the environment. What I was wondering about included:

  • How many reports are deployed?
  • How many / which reports are deployed in multiple workspaces? Which workspaces?
  • Which datasets are live ssas queries, which are direct queries, and which are embedded models?
  • Which datasources use which enterprise gateways?
  • Who are the users for each workspace?

While it is possible to find the answer to all of these questions by just clicking around in the portal on powerbi.com, some of these questions are difficult to answer or would be very time consuming to come up with an answer for. There has to be a better way, right? Enter the Power BI API.

Continue reading

© 2026 Jeff Pries

Theme by Anders Noren — Up ↑