M engine error

[Anonymous]

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 : "Failed to save modifications to the server. Error returned: 'M Engine error: 'System; The directory name C:\Users\[user name]\AppData\Local\Microsoft\Power BI Desktop\CertifiedExtensions is invalid.'. 

I checked the query and there are no errors there.

I tried closing the power bi desktop multiple times and retried but in vain. Any guidance would be appreciated. Thanks!

[Pragati11 · Accepted solution]

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]

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...