Power BI
Needs VotesPowerBI doesn't support SDK to create powerbi object and operate the object programmatically.
on 30 Mar 2017 02:40:29
PowerBI doesn't support SDK to create powerbi object and operate the object programmatically. This limitation ends my fully automated workflow ends at PowerBI, I have to manually craft PowerBIs. It makes my solution not scale. Comparing to Excel, this can be done in Excel but the UX trend goes to PowerBI.
Here is what I consider this gap can be remediated by simply support below,
* Create an PowerBI object or open from pbix file programmatically
* Able to add query
* Able to modify query M script (inject text)
* Able to add DAX text
Above will provide quite bit of flexibility to automate a lot of PowerBI user experience. Just an idea before full balloon SDK.
* Able to
- Comments (2)
RE: PowerBI doesn't support SDK to create powerbi object and operate the object programmatically.
To support column headings in different languages I discovered that I could make changes in the "Layout" file within the zip (.pbix). But if I make any changes to the file, however small, then copy the modified Layout file back into the zip then rename back to .pbix, then they would not open with Power BI Desktop - error message "This file is corrupted or was created by an unrecognized version of Power BI Desktop. It can't be opened".
This proposal would put such changes on a professional level. It has my whole-hearted approval.
RE: PowerBI doesn't support SDK to create powerbi object and operate the object programmatically.
I would be happy with the option to be able to build a PowerBI model using some external DAX code, perhaps importing formulas created in Excel into the PowerBI model to create Measure tables where there are a lot of similar measures that could be created from an Excel / PowerBI formula. The only problem is that you can't then execute the DAX as it's stored in a column in the PowerBI model, not in a DAX measure. I would like to be able to take the DAX I crafted and create a measure automatically using the PowerQuery Editor. i.e. pass the text from the PowerQuery into a Measure. I'm thinking a simple table in PowerQuery where the columns are Measure Name and DAX Expression, or even just Measures where the column includes the name e.g. {MeasureName}={DAX Expression}