VARCHAR vs NVARCHAR when using DirectQuery in Power BI

I am currently designing reports in Power BI using DirectQuery to connect to Azure SQL Server. The reports that I am designing are performance sensitive since I need to show all the rows in a table v...