I'm trying to encapsulate a query in a view to another SQL Server database (in the same server than the one I'm currently using) but it does not bring any rows or data in PowerApps.
The view works when SQL querying it, I have simplify it to be just a SELECT but still no results. The weird thing is that, when I check at the variable assigned to, PowerApps can determine what fields should be returned, but no rows.
What could be wrong? I thought that by encapsulating in a view, it should work no problem
