Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Analyze in Excel Error: OLE DB or ODBC Error

Yesterday everything was working fine without issue however I've been getting a new error this morning when trying to add values in a pivot table. It's been the same datasets for months; Newer versio...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  Anonymous ,

 

Did you encounter this error message “the field you area moving cannot be placed in that area of the report” when adding Value to pivot table, you can view the following link if you encounter it.

https://community.powerbi.com/t5/Service/the-field-you-are-moving-cannot-be-placed-in-that-area-of-the/m-p/68313

https://community.powerbi.com/t5/Service/The-field-you-are-moving-cannot-be-placed-in-that-area-of-the/m-p/1650791

 

You can check the relevant limitations of Analyze in Excel:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#considerations-and-limitations

 

Best Regards,

Liu Yang

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Liu,

     

    I did not receive that error. The only error I received was the one I shared. The connection was working fine fro a year, right up until Thursday. Now I cannot do anything with it. I even tried generating a new Excel file directly form the master dataset, but it didn't work.