Report Server Sept 2019 Release - Row Level Secruity using Direct Query problem.

[Anonymous]

I've been following the instruction posted:
https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server

I've created two roles in power BI desktop and they work correctly.
When I save the PowerBI report to the report server I get the error message.

Row-level security is not available for reports using Direct Query with integrated authentication. Learn more

According to: https://docs.microsoft.com/en-us/power-bi/report-server/row-level-security-report-server
" You can also configure RLS on reports that use DirectQuery, such as SQL Server. Keep in mind that RLS isn't respected if your DirectQuery connection uses integrated authentication for report readers. "

So I changed my Direct Query Connection in the Power BI desktop to database authentication.
However this did not fix the problem.  I guess I don't understand what needs to be configured to get Direct Query with RLS setup.
Can you provide more detail on the configuration to do RLS and Direct Query?

Thanks

[Anonymous · Accepted solution]

I guess the documentation was not clear it's not Datasource in PowerBI Desktop that needs to change. 
Once uploaded to the Report Server, the datasource must be changed within Report Server to access RLS settings.