Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I am trying to add a file type data source using REST API, however it is failing. I have tried with Service Principal as well as a usual user with PBI Pro license and admin rights on the gateway but no luck. I am wondering if I can get some help and can be guided in the right direction.
My calls are as below
JSON For data source connection
{
"datasourceName": "testDataSource",
"credentialDetails": {
"encryptedConnection": "Encrypted",
"credentialType": "Windows",
"credentials": {
"UserName": "<user_name_or_service_principal_ID>",
"Password": "System.Security.SecureString"
},
"privacyLevel": "Organizational",
"encryptionAlgorithm": "None"
},
"dataSourceType": "=File",
"connectionDetails": "{\"FilePath\":\"C:\\Working\\some.csv\"}"
}
REST API End Point
https://api.powerbi.com/v1.0/myorg/gateways/<gateway_id>/datasources
Error
Invoke-WebRequest : The remote server returned an error: (400) Bad Request.
Thanks
Kaz
Hi @Anonymous ,
Please refer the following posts, they might be helpful.
If it doesn’t meet your requirement, we suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |