Forum Discussion
PowerBi update 2019 January Direct Query Error!!!!
Hi all, We updated the Power BI Report Server with Jan'19 version and we are taking the direct query error. The reports open the Power BI Desktop (January 2019) with no issue. After we save as th...
Our Directquery reports fail, since we installed the updates.
If your data direct query from SQL Server, the auth must use windows auth. if use basic auth will error.
Thank you vvnck, using Windows authentication rather than basic authentication worked for my issue. I'd still like to see the issue fixed, but this is good workaround in my case. Thanks for posting.
Thank you! I changed the authentication method to an active directory user, with the necessary rights, to try out and it worked.
Is this common knowledge, that you should not use basic authentication with reports using directquery, or is this something new?Must be somehting new as we use SQL logins on some of our direct query reports
