Forum Discussion

alakiran's avatar
alakiran
Regular Visitor
8 years ago

Importing 320 million

Hi,   I am trying to import a large data set of 320 million rows into powerbi desktop and it is failing with below error. Any suggestions/ help?   Apply query changes Failed to save modification...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi alakiran

 

Remove any columns you don't need.  Do you have any columns that have highly unique columns?

 

Do you have any DateTime data values?

 

What is your data source?

alakiran's avatar
alakiran
Regular Visitor
8 years ago

Yes, I think i selected 6-8 columns out of 30 columns and it is still failing with the error. Yes, There is a datetime column out of those selected columns.

  • eniX's avatar
    eniX
    Helper III
    8 years ago

    Maybe try to separate your data into buckets with rownum and append the queries in the end?