Forum Discussion

npatten's avatar
npatten
Helper II
8 years ago

Error message

Hi-- I keep getting this error message, below, and the PBI instructions suggested posting the error on the forum. I can't open the document and it's crippled my analytics flow.    Feedback Type: F...
Need Help
npatten's avatar
npatten
Helper II
8 years ago
PrasanthKumar wrote:

Hi npatten

 

Can you please update your power bi desktop to latest version?

Note: If you are using the latest version of power bi desktop, please uninstall it and install latest version.

 

Please try once and let me know.

 

Thanks,

Prasanth.C

 

Hi -- uninstalled and reinstaled the desktop app through the msft store, and it still returned an error:

 

Error Message:

Failed to save modifications to the server. Error returned: 'An unexpected error occurred (file 'pcmetadatacoll.inl', line 2906, function 'PFQSortDataManipMajorObjByUserOrdinal<class ASDetail * *>::Compare').

An unexpected error occurred (file 'pcmetadatacoll.inl', line 2906, function 'PFQSortDataManipMajorObjByUserOrdinal<class ASDetail * *>::Compare').

An unexpected error occurred (file 'pcmetadatacoll.inl', line 2906, function 'PFQSortDataManipMajorObjByUserOrdinal<class ASDetail * *>::Compare').

An unexpected error occurred (file 'pcmetadatacoll.inl', line 2906, function 'PFQSortDataManipMajorObjByUserOrdinal<class ASDetail * *>::Compare').

An unexpected error occurred (file 'pcmetadatacoll.inl', line 2906, function 'PFQSortDataManipMajorObjByUserOrdinal<class ASDetail * *>::Compare').

An unexpected error occurred (file 'pcmetadatacoll.inl', line 2906, function 'PFQSortDataManipMajorObjByUserOrdinal<class ASDetail * *>::Compare').

An unexpected exception occurred.

An unexpected exception occurred.

 

---

 

Thank you,

 

Nathan

PrasanthKumar's avatar
PrasanthKumar
Frequent Visitor
8 years ago

Solution 1: If possible, can you please create a new report with the same query you are using now in the existing one (which you are facing problem now)?

 

Solution 2: https://support.microsoft.com/en-in/help/4016805/fix-the-sql-server-analysis-service-encounters-an-internal-error-when

https://support.microsoft.com/en-us/help/4014013/fix-unexpected-error-occurs-when-you-process-a-table-in-a-tabular-mode

 

Please try above solutions and let me know. I hope it will resolve your problem.

 

Thanks,

Prasanth.C

  • npatten's avatar
    npatten
    Helper II
    8 years ago

     

    Hi 

     

    Solution 2: i'm not using SSAS or SS 2016, only Power BI. I'm not sure how the solutions for Update 2, SP1 will help in this situation?

     

    Soultion 1: the current data model i'm working with is comprised of multiple SQL queries, Excel tables, and websites, along with dozens and dozens of measures. Rebuilding it from memory would be imossible. Is there a way of getting a higher level of technical support from Microsoft for my issue? It's my fundamental BI tool and i've been without for over a week.

     

    Thank you,

     

    Nathan

    • npatten's avatar
      npatten
      Helper II
      8 years ago

      Hello--

       

      On a whim, i tried to open my malfunctioning PBI docs in an older version of PBI desktop (not the app),  and the docs now work. This leads me to suspect that the PBI app is not working properly. Here is the desktop version that worked: 2.54.4970.961 64-bit (January 2018)

       

      Using an outdated version of PBI doesn't seem to be a long term solution to this problem. What are the next steps?

       

      Thank you,

       

      Nathan