topic Re: Update SSAS Live dataset connection via Power BI API in Developer

Update SSAS Live dataset connection via Power BI API

Anonymous — Wed, 13 Sep 2017 23:05:32 GMT

Hi All,

After publishing a report(SSAS Live) to the service, I am trying to access the report from my app and update the connection string using the code below but I always get an error "Operation returned an invalid code, "BadRequest"". The SetAllDatasetConnectionsInGroup worked fine for all DirectQuery reports we had. We are trying to switch over to SSAS for better performance.

P.S. I am trying to use the CustomData property of the SSAS connectionString to pass in the custom value for RLS

Snippet

try
{
    if (!string.IsNullOrEmpty(connectionString))
    {
        var connectionDetails = new ConnectionDetails()
        {
            ConnectionString = connectionString
        };
        var powerBiClient = await _client.GetPowerBiClient();
        var response = powerBiClient.Datasets.SetAllDatasetConnectionsInGroup(groupId, datasetId, connectionDetails);
        LogHelper.LogInfo(string.Format("Dataset {0} in workspace {1} update with connection string {2}", datasetId, groupId, connectionString));
 
        return TaskStatus.Completed;
    }
    else
    {
        LogHelper.LogError("Connection String cannot be null or empty");
        return TaskStatus.Failed;
    }
}
catch (Exception ex)
{
    LogHelper.LogError(ex);
    return TaskStatus.Failed;
}

Re: Update SSAS Live dataset connection via Power BI API

Eric_Zhang — Thu, 14 Sep 2017 03:11:34 GMT

@Anonymous wrote:

Hi All,

P.S. I am trying to use the CustomData property of the SSAS connectionString to pass in the custom value for RLS

Snippet

try
{
    if (!string.IsNullOrEmpty(connectionString))
    {
        var connectionDetails = new ConnectionDetails()
        {
            ConnectionString = connectionString
        };
        var powerBiClient = await _client.GetPowerBiClient();
        var response = powerBiClient.Datasets.SetAllDatasetConnectionsInGroup(groupId, datasetId, connectionDetails);
        LogHelper.LogInfo(string.Format("Dataset {0} in workspace {1} update with connection string {2}", datasetId, groupId, connectionString));
 
        return TaskStatus.Completed;
    }
    else
    {
        LogHelper.LogError("Connection String cannot be null or empty");
        return TaskStatus.Failed;
    }
}
catch (Exception ex)
{
    LogHelper.LogError(ex);
    return TaskStatus.Failed;
}

@Anonymous

AFAIK, it is a limitation. The underlying REST API Set All Connections only supports DirectQuery datasource, the SSAS live connection is not treated as DQ mode anyhow.

Re: Update SSAS Live dataset connection via Power BI API

Anonymous — Mon, 04 Dec 2017 05:05:51 GMT

I really hope this is not the case...

Re: Update SSAS Live dataset connection via Power BI API

Anonymous — Mon, 04 Dec 2017 05:23:29 GMT

You cannot update dataset connection string if you have a SSAS live connection report. We are struggling maintaining model per client.. its crazy!

Re: Update SSAS Live dataset connection via Power BI API

Anonymous — Mon, 04 Dec 2017 09:33:39 GMT

I have approximately 5000 individual reports, each with a specific connection string. We need to change them to imported mode. I can change the connection string while they are using direct query. But they are sluggish as hell unless we change them to imported mode.