Forum Discussion

Raph's avatar
Raph
Helper III
6 years ago
Solved

DataFormat.Error after having copied a query from Desktop to Dataflow

Hello   I have made a copy/paste of a query from Power BI Desktop (which works well) to Dataflow.  On Dataflow environment I have a new error : "Error: DataFormat.Error: We couldn't parse the inpu...
Need Help
  • Raph's avatar
    Raph
    6 years ago
    It's OK, I managed to load the data in 1 hour 50 minutes... Thank you Raphael
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Raph 

Could you show me a simple example with only date columns and the query you paste?

 

Best Regards

Maggie

  • Raph's avatar
    Raph
    Helper III
    6 years ago

    Dear v-juanli-msft  & AlB 

     

    Thank you for your answer. After havong done a long search, it appeared that that 2 csv files were kinf of "corrupted" when I copied pasted them on sharepoint... some lines were replaced by strange symbols. So I fixed this and thought everything was OK but now the dataflow refresh fails because of : 

     

    Error: Refreshing an entity exceeded the 2 hour refresh limit.

     

    I don't know if it will be possible to fix this new error.

     

    Thanks again

    Raphaël

    • Raph's avatar
      Raph
      Helper III
      6 years ago
      It's OK, I managed to load the data in 1 hour 50 minutes... Thank you Raphael