topic Re: Power BI - Create and Build DataSet Programaticaly in Developer

Power BI - Create and Build DataSet Programaticaly

RobinDelage — Wed, 08 Mar 2023 08:34:34 GMT

Hi,

I Would like to create new dataSet (build from the ground) but without Power BI Desktop

Those dataset are full based on SQL Server Views.

I would like to :

Générate DataSet
Add DataSource
Change type of all colones (Decimale place, Date format, etc...)
Rename / change / hide columns
Add calculated Measures and Columns
Link the DataSource
Publish Dataset
etc...

Re: Power BI - Create and Build DataSet Programaticaly

luisrh — Thu, 09 Mar 2023 00:19:08 GMT

If you want to do this in power BI service (Powerbi.com) then you need to leverage the API - Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn to do that.

If you are using PBI RS, there is also an API but it doesn't have all the capabilities of the service API -

PBIRS | 2.0 | microsoft-rs | SwaggerHub

good luck.

Re: Power BI - Create and Build DataSet Programaticaly

RobinDelage — Thu, 09 Mar 2023 08:30:13 GMT

Hi luisrh,

Thank you for the answer,

So i can do anything i do for dataset in Power BI Desktop but with the API ?

Or is there any feature that are not available ?

Re: Power BI - Create and Build DataSet Programaticaly

luisrh — Thu, 09 Mar 2023 16:32:43 GMT

Some of the visual constructs you do on power bi you are not capable to do in the API. Creating datasets, updating data sources, refreshing, etc are all things you do in the API. Building visuals and some of those finer points are doable in powerbi.com and powerbi desktops.