Forum Discussion

latheesh89's avatar
latheesh89
Icon for Helper II rankHelper II
9 years ago

Unable to update connection string using SetAllConnections API

Dear Techies,

 

I was successfully able to upload PBIX files to PBI Service using Import API. Now, I am trying to update the connection string using SetAllConnections API. The dataset that I am trying to update is using SQL Server as source and DirectQuery mode

 

Below is my query snippet, I am getting 404 bad request error

 

private static void UpdateConnection(string DatasetID)

        {

            string powerBIDatasetsApiUrl =String.Format("https://api.powerbi.com/v1.0/myorg/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=XXXXX;initial catalog=XXXXX;persist security info=True;encrypt=True;trustservercertificate=False\"}";

           

            //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(); ----Error at this line

                //Console.WriteLine(string.Format("Dataset {0}", response.StatusCode.ToString()));

                Console.ReadLine();

            }

 

        }

 

 

Am I missing something? Please help

 

Thanks,

Latheesh

3 Replies

    • latheesh89's avatar
      latheesh89
      Icon for Helper II rankHelper II

      Thanks Eric,

       

      I even tried removing myorg, but my error didn't get resolved.

      • Eric_Zhang's avatar
        Eric_Zhang
        Icon for Microsoft Employee rankMicrosoft Employee

        latheesh89 wrote:

        Thanks Eric,

         

        I even tried removing myorg, but my error didn't get resolved.


        latheesh89

        Where is the dataset in your case? If in some group, you'll specify the groupid in the POST request url. Can you double comfirm that the datasetid is correct?