We have Excel spreadsheet with PowerBI query calling a data source type of SQL Server when run on MacOS now gives are uses the following error: The evaluation was canceled because it contained a native database query for the data source with kind SQL. See screen capture below. Some other Excel / PowerBI queries work fine on Mac but we cannot see the difference in the code with one that works vs. not working. The one working does not show up the native query warning.
All of these reports/queries run perfectly in Excel for Windows. we have made sure "Require user approval for new database queries" is un-checked. Same issue. Currently, have a ticket open with Microsoft too with no luck yet.
According to users, these native query reports did work then suddenly stopped working. Not sure if that's true or not.
Any thoughts or advice/ suggestions would be amazing.
We see that you mentioned that a support ticket has been opened and the engineers will do their best to resolve your issue. I can't reproduce your issue at this time, but we will discuss it with other colleagues and gather feedback to see if there is any feedback from other users with similar experiences to yours.