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

    4d08b51f a8ac-40ce-9dbf-77a9c56ce18d on 05 Jul 2020 22:51:23

    RE: Power BI Designer and PowerShell better together

    A good example is a file with server drive sizes eg
    Drive_Letter,Size,Used_Space. This can be easily extracted using powershell into a CSV file. It would be to be able to run this script directly from Powerbi into a query.

    Cheers

    Sasa Juratovic's profile image Profile Picture

    e55db10d c2b1-4fc5-bd7e-b93228892487 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

    97c4be03 2573-4df9-a795-a580177a3072 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

    57262d06 a363-4761-b5f2-9e67ec22096f 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

    f1df7faf 9fd1-4c74-895a-ba032c3ce8f4 on 05 Jul 2020 22:35:00

    RE: Power BI Designer and PowerShell better together

    Great Idea

    Sasa Juratovic's profile image Profile Picture

    290ec21c 5125-448b-9716-69ecd17163be on 05 Jul 2020 22:34:56

    RE: Power BI Designer and PowerShell better together

    Great idea

    Sasa Juratovic's profile image Profile Picture

    171b4fd2 56ff-43f8-8043-56d3ee84934d 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

    1a64e4ed ae0e-4019-8084-de8d3bb67e91 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

    e9d54007 6552-4c7c-bc9d-487aeba6960d 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

    c94cd4b5 ffea-4d3c-94a2-8c40f625599d 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.