Skip to main content
Microsoft Idea

Power BI

Needs Votes

Power BI Designer and PowerShell better together

Vote (340) Share
Sasa Juratovic's profile image

Sasa Juratovic on 10 Jun 2015 22:29:58

Are there any plans for Power BI Designer "better together" with PowerShell? I would be able to "Get Data -> PowerShell" where I would point designer to a PS script. Designer would execute PS script and resulting tables (one or more) would be loaded into data model.

I understand I can do it today via CSV files but that requires some additional steps (and creation of CSV files) compared to what I have in mind.

Comments (13)
Sasa Juratovic's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:25

RE: Power BI Designer and PowerShell better together

The REST API should be provided as Powershell cmdlets. At the same time you implement a new API call a correspondong cmdlet should be implemented

Sasa Juratovic's profile image Profile Picture

Achin on 05 Jul 2020 22:13:44

RE: Power BI Designer and PowerShell better together

Hi Sasa, I think what you have highlighted is needed to programatically take control of features of Power BI. It will be great if you can give brief description of solution by csv files.

Sasa Juratovic's profile image Profile Picture

Kurt Falde on 05 Jul 2020 22:00:25

RE: Power BI Designer and PowerShell better together

Create and publish a Powershell Module that makes it easy for IT Pros to encapsulate data sources they already have onsite and upload them via the Power BI REST API