cancel
Showing results for 
Search instead for 
Did you mean: 

Inserting a Directquery table

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.

 

Capture 3.JPGCapture 2.JPGerror.JPG

Status: Investigating

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

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

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

Pilon4
Regular Visitor

Thanks Robert, i will be looking at these solutions this morning!

-Ethan

Pilon4
Regular Visitor

Also I did try selecting the tables, I forgot to mention that. Both the manual SQL and selecting tables do not work. 

v-robertq-msft
Community Support

Hi, 

In my opinion, if you want to get a solution for this kind of inserting tables problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft to have a remote session them to help you to make sure if this is an issue existing in the Power BI.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin