Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

M engine error

Hi,    I am connecting to an on-prem sql server from power bi desktop. I can load the data into the query editor properly but once i try to apply changes and close i keep getting this message : "Fa...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    Try disabling this option in Power BI Desktop:

    Save Power Bi file and try again your SQL Server connection.

     

    If the above doesn't work, open Power BI Desktop as an admin and then try your database connection.

     

     

    Thanks,

    Pragati

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi Anonymous ,

 

Try disabling this option in Power BI Desktop:

Save Power Bi file and try again your SQL Server connection.

 

If the above doesn't work, open Power BI Desktop as an admin and then try your database connection.

 

 

Thanks,

Pragati

  • Shawn_Eary's avatar
    Shawn_Eary
    Advocate V
    4 years ago

    I really appreciate Pragati11's help, but I didn't see "Store datasets using enhanced metadata format" as an option to disable in "Preview Features".

     

    Per her suggestion, I had to run Power BI as and admin for my Direct Query SQL connection. Why should I have to run Power BI with admin rights just to access an SQL Server DB via Direct Query?

     

    ALSO: Microsoft, please create a GNU\Linux version of Power BI. I don't like the naming convention of GNU\Linux background drivers, but I find myself primarly using GNU\Linux at work. There should be a Microsoft sanctioned flavor of GNU\Linux that does not name background drivers daemons. People should not feel like "criminals" for using the Wine emulation layer which sometimes works better with older programs than native Windows 10...