How can large datasets be loaded using Rest API from Power BI?

[sferro24]

We are using the Power BI Desktop application to create reports and load data from the API using the Web option. The API returns JSON, which we convert to a table for our reports. However, we encounter an error (“The current preview value is too complex to display”) when the API returns large datasets, specifically a table with 200 columns and 2,000 rows. Smaller datasets work without any issue.

Is there a limitation with the Power BI application on dataset loading? Is there a better approach?

Thank you.

[Anonymous]

Hi, @sferro24 

Please check out the links below and hope it can help you.

Solved: Preview.Error: The current preview value is too co... - Microsoft Fabric Community

Solved: ODBC PostgreSQL: The type of the current preview v... - Microsoft Fabric Community

Solved: table.selectrows custom colum results in "too comp... - Microsoft Fabric Community

Best Regards,

Community Support Team _Charlotte

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

[lbendlin]

Can you not ignore that and do your parsing manually?