topic Re: Create a new Power BI Report using C# in XMLA Endpoint in Developer

Create a new Power BI Report using C# in XMLA Endpoint

Don-Bot — Tue, 03 Oct 2023 19:41:14 GMT

I've worked through the Learning TOM code and have successfully created a dataset in Powe BI Service with it. I can go into it manually and create my own reports from scratch.

However, is there a way I can create a power bi report using C# and XMLA Endpoint? My end goal is to publish the dataset I can now create with it's own blank report that users can just edit and adjust on their own in embeded.

Here are links I've gone through but I haven't found anything yet.

https://github.com/PowerBiDevCamp/Tabular-Object-Model-Tutorial/blob/main/Solution/Exercise04/PBI-Tool/Program.cs

https://www.sqlservercentral.com/blogs/power-bi-meets-programmability-tom-xmla-and-c

https://www.powerbidevcamp.net/articles/programming-datasets-with-TOM/

Re: Create a new Power BI Report using C# in XMLA Endpoint

lbendlin — Wed, 04 Oct 2023 21:13:54 GMT

Look at reports in notebooks. They use some AI functions for a basic report layout based on the provided data.

Announcing Power BI in Jupyter notebooks | Microsoft Power BI Blog | Microsoft Power BI

Re: Create a new Power BI Report using C# in XMLA Endpoint

Don-Bot — Mon, 09 Oct 2023 14:44:44 GMT

Thank you for the reply @lbendlin I was actually able to accomplish this utilizing REST API scripts. Although now I am working on how to create an access token programmatically.

using System; using System.Net.Http; using System.Text; using System.Threading.Tasks; namespace Learning_TOM { internal class ReportClone { static readonly HttpClient client = new HttpClient(); public static async Task callReportCloneRestAPI() { try { var reportName = "REPORT_NAME"; var reportID = "REPORT_ID"; var targetModelID = "MODEL_ID"; var targetWorkspaceID = "WORKSPACE_ID"; var bearer = "TOKEN"; var url = $"https://api.powerbi.com/v1.0/myorg/reports/{reportID}/Clone"; var data = "{\r\n \"name\": \"" + reportName + "\",\r\n \"targetModelId\": \"" + targetModelID + "\",\r\n \"targetWorkspaceId\": \"" + targetWorkspaceID + "\"\r\n}"; client.DefaultRequestHeaders.Add("Authorization", "Bearer " + bearer); var content = new StringContent(data, Encoding.UTF8, "application/json"); HttpResponseMessage response = await client.PostAsync(url, content); response.EnsureSuccessStatusCode(); string responseBody = await response.Content.ReadAsStringAsync(); Console.WriteLine(responseBody); } catch (Exception ex) { Console.ForegroundColor = ConsoleColor.Red; Console.WriteLine("Error copying reports: " + ex.Message); Console.ResetColor(); } } } }

Re: Create a new Power BI Report using C# in XMLA Endpoint

lbendlin — Mon, 09 Oct 2023 14:49:20 GMT

I thought your request was for creating a report from scratch, rather than cloning a report.