@@bitsanalytics6949 Thanks for your reply and time, No Single API's with multiple JSON objects or Arrays For Eample: {Array1[{obj1}, {obj2}, {obj3}], Array2[{obj1}, {obj2}, {obj3}]}
The issue I have is that I have many lists under the Column after converting to Table. Then within each list is a "record", so trying to Extract Values gives me an error of: Expression.Error: We cannot convert a value of type Record to type Text. Details: Value= subid=adgroup1 Type=[Type] Any ideas on how to resolve this?
Hello sir, I am using POST api to fetch the data from the data source into postman and that API have some paramters such as body parts and authentication params, which needs to passed while fetching the data, where should I pass these params in power bi, As I am already using these params in postman in Body> x-www-form-urlencoded.
I connected to jira api from power bi, here are the steps I followed- 1. Create a token for the jira api 2. Use json.document(web.content(your api url) 3. Connect using basic method 4. Provide you jira account mail if 5. Use you token as password. 6. Data will be imported after that.
![Building a Power BI Admin View [Part 1]: Connecting to Data from the REST API](http://i.ytimg.com/vi/cTqFNg_y9lw/mqdefault.jpg)
![Building a Power BI Admin View [Part 1]: Connecting to Data from the REST API](/img/tr.png)
ur video is very usefull. thanks
Hi, What if I have multiple JSON Objects or Arrays ?
Do you mean to say multiple API calls?
@@bitsanalytics6949 Thanks for your reply and time, No Single API's with multiple JSON objects or Arrays
For Eample:
{Array1[{obj1}, {obj2}, {obj3}], Array2[{obj1}, {obj2}, {obj3}]}
ua-cam.com/video/Mo49P307ngs/v-deo.html
The issue I have is that I have many lists under the Column after converting to Table. Then within each list is a "record", so trying to Extract Values gives me an error of: Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
subid=adgroup1
Type=[Type]
Any ideas on how to resolve this?
issue with JSON format.
But how can we acess the api which requires the acess token
there is work around for that.
ua-cam.com/video/Mo49P307ngs/v-deo.html
Hello sir, I am using POST api to fetch the data from the data source into postman and that API have some paramters such as body parts and authentication params, which needs to passed while fetching the data, where should I pass these params in power bi, As I am already using these params in postman in Body> x-www-form-urlencoded.
ua-cam.com/video/Mo49P307ngs/v-deo.html
How can i access authentic rest API in power bi of json data source
ye can do. by using the web authentication method. or with language M.
I connected to jira api from power bi, here are the steps I followed-
1. Create a token for the jira api
2. Use json.document(web.content(your api url)
3. Connect using basic method
4. Provide you jira account mail if
5. Use you token as password.
6. Data will be imported after that.
awesome..!!!
ua-cam.com/video/Mo49P307ngs/v-deo.html
Hello Sir,
I am using POST method to call XML API but it's not showing proper results. In this format how to solve, please give me advice.
Lesson 18 Create REST API GET method with Windows Authentication and consume into Power BI Desktop.
ua-cam.com/video/Mo49P307ngs/v-deo.html
And how to create function
I have created videos on function and its in post production. Stay tune Rohit.
Sir make more videos on rest API
Sure I will
Thank you
You're welcome
ua-cam.com/video/Mo49P307ngs/v-deo.html