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.
14 Comments
- 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
- 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.
- 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
- Did you try this: https://github.com/DevScope/powerbi-powershell-modules?
- 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.
- Great idea
- 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.
- I strongly believe that this is a great idea. THANKS
- Oh please yes... Anything to help the automation process...
- Great Idea
