https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/849513#M12202 <P>Error? Did you manage for proper credentials?</P> Mon, 18 Nov 2019 22:33:54 GMT bradsy 2019-11-18T22:33:54Z https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/849186#M12194 <P>We recently upgrade to PBIRS and are excited to take advantage of leveraging PBI on-premise.&nbsp;&nbsp;<BR /><BR /></P><P>We have created some basic PBIX files that are configured as Direct Query.&nbsp; They work fine in PBI desktop, however, we get the following error when trying to run the PowerBI report after it has been uploaded.</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Mon, 18 Nov 2019 16:41:18 GMT https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/849186#M12194 teconsultant 2019-11-18T16:41:18Z https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/849513#M12202 <P>Error? Did you manage for proper credentials?</P> Mon, 18 Nov 2019 22:33:54 GMT https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/849513#M12202 bradsy 2019-11-18T22:33:54Z https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/879271#M12518 <P>Some updates, and then I will show the error...</P><P><BR />Following the steps in this article (we are using SQL server instead of Analysis Services)<BR /><A href="https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports" target="_blank" rel="noopener">https://docs.microsoft.com/en-us/power-bi/report-server/configure-kerberos-powerbi-reports</A></P><P>&nbsp;</P><OL><LI>Authentication type within Report Server config.</LI><LI>SPNs for the report server service account.&nbsp; (this isn't needed since we are using Virtual Service Account in PBIRS)</LI><LI>SPNs for the Analysis Services service. (SQL Server)</LI><LI>SPNs for the SQL Browser service on the Analysis Services machine. This is for named instances only.</LI><LI>Delegation settings on the report server service account.<P>The interesting thing is, now I am able to pull up test PBI reports, and I am getting mixed results.<BR />as a power user (same user who was able to create reports) I can view them from any machine except for on the local report server.<BR /><BR />I have 1 test PBI report with DQ that can be viewed from almost any user.&nbsp; However, if i create another similar simple report, we get the same generic error.&nbsp; Is there any way of getting PBIRS to provide a more detailed message?<BR /><BR /></P><DIV class="infonav-dialogTitle">An unexpected error occurred<DIV class="infonav-dialogContent"><DIV>An unexpected error occurred. Please try again later.<BR />Please try again later or contact support. If you contact support, please provide these details.<BR /><DIV><DIV class="infonav-errorInfoItem"><SPAN class="infonav-errorInfoHeader"><SPAN class="infonav-errorInfoHeader">We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.</SPAN></SPAN><DIV class="infonav-errorInfoItem"><SPAN class="infonav-errorInfoHeader"><SPAN class="infonav-errorInfoHeader">Request ID<SPAN class="infonav-errorInfoText">e61dd989-ba98-8c66-78dd-b743444bff06</SPAN></SPAN></SPAN><DIV class="infonav-errorInfoItem"><SPAN class="infonav-errorInfoHeader"><SPAN class="infonav-errorInfoHeader">Time<SPAN class="infonav-errorInfoText">Wed Dec 18 2019 14:37:16 GMT-0500 (Eastern Standard Time)</SPAN></SPAN></SPAN><DIV class="infonav-errorInfoItem"><SPAN class="infonav-errorInfoHeader">Version<SPAN class="infonav-errorInfoText">15.0.1102.371</SPAN></SPAN></DIV></DIV></DIV></DIV></DIV></DIV></DIV></DIV></LI></OL> Wed, 18 Dec 2019 19:54:15 GMT https://community.fabric.microsoft.com/t5/Report-Server/Unable-to-perform-Direct-Query-against-SQL-Server/m-p/879271#M12518 teconsultant 2019-12-18T19:54:15Z