Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
RobinDelage
New Member

Power BI - Create and Build DataSet Programaticaly

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...

 

3 REPLIES 3
luisrh
Responsive Resident
Responsive Resident

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.

RobinDelage
New Member

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 ?

luisrh
Responsive Resident
Responsive Resident

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors