Skip to main content

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:46:37

RE: Power BI Designer and PowerShell better together

Please start this work asap.

Sasa Juratovic's profile image Profile Picture

Power BI User on 05 Jul 2020 22:37:11

RE: Power BI Designer and PowerShell better together

Why leave out powershell? It's a great too.

Sasa Juratovic's profile image Profile Picture

Power BI User on 05 Jul 2020 22:35:07

RE: Power BI Designer and PowerShell better together

I need this very badly. This is currently the best way for me to collect GitHub data that isn't supported via the GitHub connector.

Sasa Juratovic's profile image Profile Picture

Power BI User on 05 Jul 2020 22:35:00

RE: Power BI Designer and PowerShell better together

Great Idea

Sasa Juratovic's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:56

RE: Power BI Designer and PowerShell better together

Great idea

Sasa Juratovic's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:52

RE: Power BI Designer and PowerShell better together

I strongly believe that this is a great idea. THANKS

Sasa Juratovic's profile image Profile Picture

Chrissy LeMaire on 05 Jul 2020 22:34:46

RE: Power BI Designer and PowerShell better together

When you begin to move forward with PowerShell support, please consider the community feedback on the Trello board at:

https://sqlps.io/powerbi

Rob Sewell and others have proposed some PowerShell commands and ordered them for convenience and ease of understanding. A similar board has been working well for the primary SqlServer module.

Sasa Juratovic's profile image Profile Picture

tom on 05 Jul 2020 22:34:27

RE: Power BI Designer and PowerShell better together

Oh please yes... Anything to help the automation process...

Sasa Juratovic's profile image Profile Picture

Raf Delgado on 05 Jul 2020 22:26:15

RE: Power BI Designer and PowerShell better together

Run PowerShell queries to return objects which can be imported into Power BI. Really useful for gathering admin information and presenting in a visual format.

Sasa Juratovic's profile image Profile Picture

Jose Antonio Silva 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?