Unanswered

Bulk Data load into Dataverse - Error

(0) Share

Report

Posted on by ctedesco3307

690

Looking for directional info on loading a lot of data into Dataverse - I have a --insert flow working that fails out after 13000 to 15000 records. I get an erroneous error "Invalid JSON Format" every time. There are 59681 records to be loaded, so it's a lot. The JSON is formatted right - I've triple checked that - I know it's hard to answer a q like this without seeing it, but thought I'd throw it out there for ideas.

Thx

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @ctedesco3307

Can you share what data source you are using? You can also try dataflows to import large data into dataverse.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
ctedesco3307 690 on at

Like (0)

Report

@yashag2255 I'm querying data from a Power BI dataset. How would I use dataflow to get into Dataverse? I'm looking in microsoft learn - but not really seeing the steps I need. Thx!

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @ctedesco3307

You can get started on Dataflows here: https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
ctedesco3307 690 on at

Like (0)

Report

@yashag2255 - yes, I saw this already but didn't see the configuration I was looking for. I'm getting data from a Power BI dataset, importing into a dataverse table. The only option I see to do that is with the OData query, and I don't think there is a valid URL to use for the workspace dataset, is there? Thanks!!!!

Was this reply helpful? Yes No