Showing results for 
Search instead for 
Did you mean: 
Ronnie7 Helper II
Helper II

PowerBI REST API error - Need help



In effort to automate the creating of data source on a given Gateway, I have started using the PowerBI REST API commands.
I'm currently trying to create a sample data source on a specific gateway ID using the post command from PowerShell.
I went over the documentation and believe i have all the parameters correct. However, when i try to post i get the the following error:
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod


Here's my code:

"dataSourceType": "Sql",
"connectionDetails": "{\"server\":\"Server\",\"database\":\"TEST_DB\"}",
"datasourceName": "Sample",
"credentialDetails": {
"credentialType": "Basic",
"credentials": "{\"credentialData\":[{\"name\":\"username\", \"value\":\"ABC\"},{\"name\":\"password\", \"value\":\"ABC\"}]}",

Invoke-PowerBIRestMethod -url "$gatewayID/datasources" -Method post -body $body2 

$GatewayID is defined. the Get method does work and I can see all of the data source on that Gateway, but the POST just fails.

I have tried so many things and get the same error. 
Any help would be apprieciated!

Ronnie7 Helper II
Helper II

Re: PowerBI REST API error - Need help

Any Help?

Helpful resources

New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors