Dear Techies,
I have to import PBIX files to multiple workspaces. Each workspace is meant to point diffrent Analysis Services DB and we have on premises gateway for this instance. The Problem is when I try to Import PBIX files using Import API. Connection string is set same across all the workspaces. Which should not be the case, PBIX file should point to its respective Analysis Services DB in a workspace.
I am trying to use SetAllConnections API to update the connection string. But I am getting 400 bad request exception, please refer my code below
Am I missing anything here? I don't have much coding knowledge please help me out
private static void UpdateConnection(string DatasetID)
{
string powerBIDatasetsApiUrl = String.Format(" https://api.PowerBI.com/v1.0/myorg/datasets/{0}/Default.SetAllConnections", DatasetID);
HttpWebRequest request = System.Net.WebRequest.Create(powerBIDatasetsApiUrl) asSystem.Net.HttpWebRequest;
request.KeepAlive = true;
request.Method = "POST";
request.ContentLength = 0;
request.ContentType = "application/json";
//Add token to the request header
request.Headers.Add("Authorization", String.Format("Bearer {0}", token));
string updateJSON = "{\"connectionString\":\"data source=DEVXXXX;initial catalog=XXX;Cube=Occupancy;persist security info=False\",\"ConnectionType\":\"analysisServicesDatabaseLive\"}";
//POST web request
byte[] byteArray = System.Text.Encoding.UTF8.GetBytes(updateJSON);
request.ContentLength = byteArray.Length;
//Write JSON byte[] into a Stream
using (Stream writer = request.GetRequestStream())
{
writer.Write(byteArray, 0, byteArray.Length);
var response = (HttpWebResponse)request.GetResponse();
Console.ReadLine();
}
}
Please post the sample code
Thanks in Advance,
Latheesh
