Forum Discussion
Unable to create Datasource on PowerBI API
Hi nk-alex ,
Great question unfortunately, DAX in Power BI is just for calculations and modeling, so it can't make REST API calls, handle encryption, or talk to gateways. The datasource creation you're working on happens outside of Power BI, so you'll need to use something like PowerShell, Postman, or a backend script in Python or C# to get that done.
If you just want to see or build the JSON body, Power Query can help with that, but it still can't do encryption or actually create the datasource through the API. Those parts have to be done with external tools to keep things secure.
So, DAX isn't able to test or set up this process you'll need an external tool that can handle encryption and REST API requests.
Thank you.
Hi nk-alex ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.
Hi v-tejrama I have followed your steps and still not able to connect. Is my sent body correct?
Hi nk-alex ,
Great question unfortunately, DAX in Power BI is just for calculations and modeling, so it can't make REST API calls, handle encryption, or talk to gateways. The datasource creation you're working on happens outside of Power BI, so you'll need to use something like PowerShell, Postman, or a backend script in Python or C# to get that done.
If you just want to see or build the JSON body, Power Query can help with that, but it still can't do encryption or actually create the datasource through the API. Those parts have to be done with external tools to keep things secure.
So, DAX isn't able to test or set up this process you'll need an external tool that can handle encryption and REST API requests.
Thank you.