Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

M query error

My desktop continues to show all data but the server has an error on certain visuals that says :

Unable to convert an M query in table 'Person Fields' into a native source query.

Please try again later or contact support. If you contact support, please provide these details.

 

Activity ID: a653b1ae-faa2-4f10-9710-ffba937c0302
Request ID: d0f231d3-af0d-bb96-c943-58f3e710c626
Correlation ID: 9e62f87f-745f-f36f-b713-7149b430ef18
Time: Wed Aug 17 2022 15:12:11 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.18848.49
Client version: 2208.2.12691-train
Cluster URI: https://wabi-us-east2-c-primary-redirect.analysis.windows.net/

 

Not sure what to do or why i dont see these errors in the desktop 

2 Replies

  • nvprasad's avatar
    nvprasad
    Solution Sage
    4 years ago

    Hi cmanso,

     

    It looks like one of the transformation in done on 'Person Fields' table casusing the issue while getting data from the source data. I believe you mgiht have ,connnected to the data sourdce in direct query.

     

    Kindly check transformations of 'Person Fields' table in PowerQuery Editor.

     

    Appreciate a Kudos! ‌‌
    If this helps and resolves the issue, please mark it as a Solution! ‌‌

    Regards,
    N V Durga Prasad

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    As nvprasad mentioned before, I think your data model should be Direct Query. And I find a solved post with similar issue like yours. I suggest you to refer to this post to learn more details. 

    Did you do some transform on 'Person Fields'?  I think you can try to remove some steps in Power Query Editor.

    For referenece: Solved: Unable to convert an M query in table [table name]... - Microsoft Power BI Community

    You also can refresh your report in latest version Power BI Desktop and publish your report to Power BI Service.

     

    Best Regards,
    Rico Zhou

     

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