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.