Getting Incorrect data into PBI through API

[Uzi2019]

Hi Expert,

I am trying to fetch the API code from the NetBase tool into PBI but getting duplicate row wise data into it. Even though, Response body from API code is showing unique records, but when we pull into PBI end it  duplicates 732 records against each row. (Attaching SS below)

Can anyone please help us in this matter? It's quite urgent.

TIA!

[v-luwang-msft]

Hi @Uzi2019 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Uzi2019]

No Still try to find the better solution. Once I'll get the solution of my problem will post it here.

[v-luwang-msft]

Hi @Uzi2019 ，

With Power BI Rest API calls, you can import data from websites that provide restful APIs for data access. Once the data is imported, you can treat it like any other data file such as JSON or CSV, etc.

Details ,refer the below article:

https://www.sqlshack.com/importing-data-from-json-files-and-power-bi-rest-apis-into-power-bi/ 

https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400 

https://community.powerbi.com/t5/Developer/Get-data-using-REST-API/m-p/122055 

https://community.powerbi.com/t5/Desktop/Get-Data-using-API/m-p/964390

Wish it is helpful for you!

Best Regards

Lucien