Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a problem when I want to access a table in DirectQuery. I actually get this error message:
Failed to save changes to server. Error returned: “Cannot convert query M in table 'XXXX' to native source query. The current operation was canceled because another operation in the transaction failed. "
I don't understand why this message given that I have already successfully used DirectQuery in my report.
If I do an import, no worries to use the table but I absolutely have to use DirectQuery.
If anyone has an idea I'm a taker
Thank you.
Solved! Go to Solution.
Hi @AlexisPREVOT ,
Referring to a similar solution, it seems that the problem is caused by direct query not supporting certain queries.
Solved: Error: Unable to convert an M query... - Microsoft Power BI Community
Solved: Expand column where not all records are tables - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AlexisPREVOT ,
Referring to a similar solution, it seems that the problem is caused by direct query not supporting certain queries.
Solved: Error: Unable to convert an M query... - Microsoft Power BI Community
Solved: Expand column where not all records are tables - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@AlexisPREVOT , You need to check power query steps. It might be erroring on some of the steps which not allowed in direct query.
Or have replaced source manually on the code and the for the new source direct query is not supported
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
95 | |
82 | |
71 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |