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

Month: September 2019

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

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

New Home for Code Samples – GitHub

In the past, I’ve posted my code samples for this blog in a variety of places — in OneDrive with a link, Google Drive with a link, and zipped up and stored on this site.

In an effort to get (and stay) a little more organized, I’m going to try to store new code samples going forward on My GitHub page.

We’ll see how it goes!

© 2026 Jeff Pries

Theme by Anders NorenUp ↑