Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
When bringing in a new table, I am having trouble applying data to the file through direct query methods.
I get an error message "Failed to save modifications to the server. Error returned: 'Unable to convert an M query in table 'PRTH' into a native source query.'." I have tried 2 ways of getting the table, with the recent data source tab in transform data, and getting the table , as well as source > settings > then inserting SQL. I have looked at other solutions that say to "simplify" the steps to bring the table in, and as you can see in one file I only have one step. When I load the needed table on a blank power BI file, it works fine. We have 7 tables, 4 through direct query and 3 through import including this table. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Would you like to try to simply select the tables in the connection setting page instead of using the native SQL statement to query the data source to check if the problem can disappear?
Here are some cases with similar issues, you can take a look at:
https://www.reddit.com/r/PowerBI/comments/jo0kdv/unable_to_convert_an_m_query_in_table_xxx_into_a/
https://community.powerbi.com/t5/Desktop/Unable-to-convert-an-M-query-in-table-Dataset-Table-into-a/...
https://community.powerbi.com/t5/Desktop/Error-Unable-to-convert-an-M-query/td-p/1401998
Thank you very much!
Best Regards,
Community Support Team _Robert Qin