marclelijveld / power-bi-automation

Automate tasks in Power BI based on the Power BI Powershell cmdlets and the Power BI REST API

Power-BI-Automation

Automate tasks in Power BI based on the Power BI Powershell cmdlets and the Power BI REST API

Please see the notes in the scripts for further explanation.

power-bi-automation's Issues

Fullpath variable needs to be moved up higher in script for refreshhistoryperworkspace

The reference for the Fullpath needs to be moved up in this script

Export data parameters

$FolderName = "RefreshHistoryDump"
$OutputLocation = "c:"
$DatePrefix = Get-Date -Format "yyyyMMdd_HHmm"
# Create folder to dump results
$Fullpath = $OutputLocation + $FolderName
$DefaultFilePath = $Fullpath + "" + $DatePrefix + "" + $WorkspaceId + ""

Code fails if allowNativeQueries=true

I love this code. Thank you. It will fail if the data flow accesses native sql queries.

I updated function _getPowerBIDataflowDefinition
with this
if ($flowdefinition.'pbi:mashup'.'allowNativeQueries')
{
$flowdefinition.'pbi:mashup'.'allowNativeQueries'= $FALSE
}

== here is the code snippet

function getPowerBIDataflowDefinition([string] $GroupID, [string]$DataflowName) {
$url = [string]::Format("groups/{0}/dataflows", $GroupID);
$flowItems = Invoke-PowerBIRestMethod -Method GET -Url $url | ConvertFrom-Json
$flow = $flowItems.value | Where-Object { $.name -eq $DataflowName }

if ($flow) {
    $url = [string]::Format("groups/{0}/dataflows/{1}", $GroupID, $flow.objectId);
    $flowdefinition = Invoke-PowerBIRestMethod -Method GET -Url $url | ConvertFrom-Json

    # check for allowNativeQueries
    #    "pbi:mashup": {
    #    "allowNativeQueries": false,
    if ($flowdefinition.'pbi:mashup'.'allowNativeQueries')
    {
        $flowdefinition.'pbi:mashup'.'allowNativeQueries'= $FALSE
    }

Power bi gateway configuration

I am looking for scripts to configure the on prem power bi gateway. Unable to find any docs or in built commands for automation.
Even tried doing it via pywinauto. But no luck.
Have you guys figured this out by any chance.