PowerShell" where I would point design..." /> PowerShell" where I would point designer to a PS script. Designer would execute PS scrip..."> 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." />
Skip to main content

Power BI

Needs Votes

Power BI Designer and PowerShell better together

Vote (337) 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 (14)
Sasa Juratovic's profile image Profile Picture

5c3f11a9 fb3e-4fc9-8b20-939f51e09c34 on 05 Jul 2020 22:24:14

RE: Power BI Designer and PowerShell better together

Did you try this: https://github.com/DevScope/powerbi-powershell-modules?

Sasa Juratovic's profile image Profile Picture

b1a5eb55 2181-43dc-b186-cb113f47e943 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

1e7437db 53db-42b0-8393-b2456749931c 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

11a49e0c 39e0-4504-8927-76f6fc4418b0 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