Lesson 7 Power BI Report with REST API (JSON) Data Source. Please Subscribe for free videos.

[@leonelrevelotobar9110]

ur video is very usefull. thanks

[@NicoloTonno]

Thank you

[@bitsanalytics6949]

You're welcome

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@noobystok]

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?

[@bitsanalytics6949]

issue with JSON format.

[@Explorewith_RJ]

Sir make more videos on rest API

[@bitsanalytics6949]

Sure I will

[@mani.a2914]

Hi, What if I have multiple JSON Objects or Arrays ?

[@bitsanalytics6949]

Do you mean to say multiple API calls?

[@mani.a2914]

​@@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}]}

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@akashgera5570]

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.

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@umeetmalewar4483]

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.

[@bitsanalytics6949]

Lesson 18 Create REST API GET method with Windows Authentication and consume into Power BI Desktop.

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@aparnaacharya7426]

But how can we acess the api which requires the acess token

[@bitsanalytics6949]

there is work around for that.

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU

[@Explorewith_RJ]

And how to create function

[@bitsanalytics6949]

I have created videos on function and its in post production. Stay tune Rohit.

[@bossofdata]

How can i access authentic rest API in power bi of json data source

[@bitsanalytics6949]

ye can do. by using the web authentication method. or with language M.

[@newuntidy]

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.

[@bitsanalytics6949]

awesome..!!!

[@bitsanalytics6949]

kzbin.info/www/bejne/g6CXaoNpZZyhndU