Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
latheesh89
Helper II
Helper II

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 3
Eric_Zhang
Microsoft Employee
Microsoft Employee

@latheesh89

There'a actually an error in the Set All Connections API which leads to a 404 error. Try to remove the duplicated /myorg from the Url .../myorg/myorg/...

Thanks Eric,

 

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


@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?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.