API not showing data

[alamhaz]

Dear all 

I want to get data from API in web its showing data as shown but in power bi when i want to connect with web then instead of taking this as json its take it as csv.document, and i am not getting data the web i am using is 

https://portal.payasyoutrack.com/api2.ashx?op=Report&subop=DeviceHealth&groupIDs=0&ticket=xxxxxxxx

Please guide me how can i get data from API as i am new in this i dont know where is error.

and data i am getting on web is .

[v-henryk-mstf]

Hi @alamhaz ,

I make a test:

Try using Get Data -> Web->advanced. It will detect that it's a delimited file and load in the CSV for you. You need to provide the correct url as required to get the data correctly

For the url you provided, you need to enter the corresponding credentials, which cannot be obtained directly

Refer to the following blog link, which can help you:

Importing data from JSON files and Power BI Rest APIs into Power BI (sqlshack.com)

Read API Data with Power BI using Power Query (mssqltips.com)

If the problem is still not resolved, provide detailed operation steps screenshots, I will answer you as soon as possible. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alamhaz]

Hi I can data in power bi that was problem of date i solved it but now the problem is that data is comming in only one column see the below SS, in web data is in rowset but when i import into power bi all data is in one column without heading of col, which is confusing.

[v-henryk-mstf]

Hi @alamhaz ,

Import irregular data models, you can refer to this pbix file, and you can use transform table.

Let me know the result immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Below is the sample pbix file.

[alamhaz]

I tried it but its not working 

[alamhaz]

If i expend using column it only give column name no data , but if i expend using rowset it only give data no colunm name check SS 

[v-henryk-mstf]

Hi @alamhaz ,

Did you encounter difficulties in the process of transform? Can you provide test data (delete sensitive information)? I will answer you as soon as possible.

Best Regards,
Henry

[alamhaz]

Use this to get data but use now otherwise ticket will expire.

https://portal.payasyoutrack.com/api2.ashx?op=Vehicle&subop=GetVehiclePositionsLatest&vehicleIds=681...