Hello,
I was wondering if anyone has experiance to use the Power BI API in C#?
I have created a C# .NET Console App using the PowerBI API Library to connect to the Power BI API to get a list of groups, reports, etc. I would like to use the application I am creating to access the Power BI API and get data so I can automate the analyze and audit processes.
Prior to programming I went into Azure and set up the App Registration per this document: https://www.vahiddm.com/post/call-power-bi-rest-api-with-power-automate
My C# application, I can get the token but then I get a 401 Un-authorized error. Here is the error information I get:
Non-admin groups: 0
Status: 401 Unauthorized
Response content:
Pragma: no-cache
Transfer-Encoding: chunked
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Frame-Options: deny
X-Content-Type-Options: nosniff
RequestId: 2ad55907-50ad-49e8-964b-9a7d9de14eef
Access-Control-Expose-Headers: RequestId
Cache-Control: no-store, must-revalidate, no-cache
Date: Tue, 06 Jan 2026 21:01:31 GMT
Content-Type: application/octet-stream
Here is my code that I am using:
class PowerBI
{
public async System.Threading.Tasks.Task getPowerBIWorkspaceData()
{
//instantiate the api object
API api = new API();
string accessToken = await api.getPowerBIAccessToken();
Console.WriteLine(accessToken);
var credentials = new TokenCredentials(accessToken, "Bearer");
var apiUrl = "https://[Removed]"; // Base URL for the Power BI Service API
using (var client = new PowerBIClient(new Uri(apiUrl), credentials))
{
try
{
var g = await client.Groups.GetGroupsAsync();
Console.WriteLine($"Non-admin groups: {g.Value?.Count ?? 0}");
// Example: Get a list of workspaces (groups)
var workspaces = await client.Groups.GetGroupsAsAdminAsync(top: 500);
Console.WriteLine($"Found {workspaces.Value?.Count ?? 0} workspaces.");
// You can now call other APIs, e.g., to get reports in a specific workspace
if (workspaces.Value.Count > 0)
{
var groupId = workspaces.Value[0].Id;
var reports = await client.Reports.GetReportsInGroupAsync(groupId);
Console.WriteLine($"Workspace has {reports.Value.Count} reports.");
}
}
catch (Microsoft.Rest.HttpOperationException ex)
{
Console.WriteLine($"Status: {(int)ex.Response.StatusCode} {ex.Response.StatusCode}");
Console.WriteLine("Response content:");
Console.WriteLine(ex.Response.Content);
// If headers exist, print them (sometimes the key clue is here)
if (ex.Response.Headers != null)
{
foreach (var h in ex.Response.Headers)
Console.WriteLine($"{h.Key}: {string.Join(",", h.Value)}");
}
throw;
}
}
}
}
Any help would be appreciated.
Thanks,
Tim
