Forum Discussion

Scottyuk's avatar
Scottyuk
Frequent Visitor
5 years ago
Solved

M engine integration is not enabled

Hi, I'm getting the following error trying to save/publish a report to our on prem SSRS server.

 

Looking at the log file the error is reporting the following 'M engine integration is not enabled'

I have looked for solutions, I have unchecked relationships options and i've checked for errors in the report.

 

Anyone got any ideas?

 

 

 

Need Help
  • Scottyuk's avatar
    Scottyuk
    5 years ago

    Hi, just to update the issue,

     

    I have created a blank report and created a table from within PowerBI and tried to push that to our on-prem server and i'm getting an error, looking at the logs i am now seeing this:

     

     

    2020-12-08 11:17:53.3602|ERROR|145|We're not able to upload this report. The report was created with a recent version of Power BI Desktop that is not yet supported by this server.| RequestID = s_610440ed-bc72-43b8-83be-70aa75c8cade

     

     

    My more complicated report is still showing:

     

     

    Failed to publish model for temp_193c9ad7-6184-4a85-84c8-405d67911bdf ---> Microsoft.AnalysisServices.OperationException: M engine integration is not enabled.

     

     

    Having upgraded our on-prem server i can confirm both errors are down to having a different version of PowerBI desktop compared to the on-prem server.

2 Replies

  • Scottyuk's avatar
    Scottyuk
    Frequent Visitor
    5 years ago

    Hi, just to update the issue,

     

    I have created a blank report and created a table from within PowerBI and tried to push that to our on-prem server and i'm getting an error, looking at the logs i am now seeing this:

     

     

    2020-12-08 11:17:53.3602|ERROR|145|We're not able to upload this report. The report was created with a recent version of Power BI Desktop that is not yet supported by this server.| RequestID = s_610440ed-bc72-43b8-83be-70aa75c8cade

     

     

    My more complicated report is still showing:

     

     

    Failed to publish model for temp_193c9ad7-6184-4a85-84c8-405d67911bdf ---> Microsoft.AnalysisServices.OperationException: M engine integration is not enabled.

     

     

    Having upgraded our on-prem server i can confirm both errors are down to having a different version of PowerBI desktop compared to the on-prem server.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Scottyuk 

     

    Please first check if there is any unsupported data sources / authentication methods in the report from https://docs.microsoft.com/en-us/power-bi/report-server/data-sources.

    • Some data sources are available in Power BI Desktop optimized for Power BI Report Server, but aren't supported when published to Power BI Report Server.
    • Power BI Report Server does not support OAuth-based authentication for model refresh. Some data sources such as Excel or Access databases make use of a separate step like File or Web to connect to data.
    • Power BI Report Server does not support OAuth-based authentication for DirectQuery.

     

    Then, check if there is any unsupported features in the report from https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service. Power BI Report Server and the Power BI service have some key differences which may cause this error.

     

    Kindly let me know if this helps.


    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.