Forum Discussion
ErrorCode=-2146232060, When create M Query with Parameters for DirectQuery mode
Based on the native query (which works totally fine in the DirectQuery mode), I created an M Query to add two parameters, according to the documentation: Dynamic M query parameters in Power BI Deskto...
Hi, Ning_pbi ;
According to the office document,
Sql.Database(server as text, database as text, optional options as nullable record) as table
Check the server is right.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help. I checked that the server is right, and the database is also right. But the error still exists.
