topic Re: Oct 2020 update 2 - Direct Query SQL problem remains in Report Server

Oct 2020 update 2 - Direct Query SQL problem remains

Steffe — Wed, 13 Jan 2021 14:51:16 GMT

Hi,

Just wanted to let you know that the issue described in the thread below is still present after upgrading our report server to the latest build (Version: 1.9.7675.15620 (Build 15.0.1104.300), Released: January 8, 2021). I´m also using the latest version of the Desktop for PBIRS (2.86.1321.0 64-bit (oktober 2020)).

https://community.powerbi.com/t5/Report-Server/Oct-2020-Direct-Query-SQL-problem/m-p/1556995#M17220

The problem is only present when "Store datasets using enhanced metadata format" is used.

The error messages from the log-files stated in the thread above differs somewhat. We now get this message in the ASManagedRoot log file:

|ERROR|9|GetV3ConnectionString - Exception occured while retrieving credentials for data model connection string.System.Exception: No credentials were found for the datasource
at Microsoft.PowerBI.ReportServer.ASEngineManagedRoot.PBIRSConnectionDetailsProvider.GetV3ConnectionString(Guid rootActivityId, String userPrincipalName, String engineConnectionString, String[] datasourceIds, String contextualIdentity, Boolean isDirectQueryExecution, PBIDedicatedProviderType& providerType, String& connectionString)

Re: Oct 2020 update 2 - Direct Query SQL problem remains

Icey — Fri, 15 Jan 2021 10:17:05 GMT

Hi Steffe ,

I have tested with the latest version. But I can't reproduce the issue you encountered.

Is this problem a common problem? Does anyone else meet?

Best Regards,

Icey

Re: Oct 2020 update 2 - Direct Query SQL problem remains

Steffe — Fri, 15 Jan 2021 12:00:20 GMT

Hi Icey

Thanks for looking into this.

It is strange that it works for you.

How do your environment look like? What type (onprem/azure) and version of SQL are you connecting against?

Re: Oct 2020 update 2 - Direct Query SQL problem remains

Icey — Mon, 25 Jan 2021 05:31:38 GMT

Hi Steffe ,

My SQL is SQL Server 2017 Developer and my Windows version is 10.0.19041 Build 19041.

In addition, I have confirmed internally that this bug is being fixed by the product team. This is a known issue that has been submitted internally (ICM#: 21688995). Please be patient and I will let you know if there is an update.😊

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Re: Oct 2020 update 2 - Direct Query SQL problem remains

Steffe — Tue, 19 Jan 2021 12:21:23 GMT

Thanks Icey

Then we wait for a fix 🙂

Re: Oct 2020 update 2 - Direct Query SQL problem remains

Icey — Mon, 01 Feb 2021 02:40:56 GMT

Hi Steffe ,

The January 2021 release of PBIRS is now available to download. The current PBIRS version is: 1.10.7698.12811 (Build 15.0.1105.194), Released: January 21, 2021. It fixed some bugs:

Bug fixes

Fixed issue with scheduled refresh of Power BI reports with certain models using enhanced model metadata.

Fixed issue editing data driven subscriptions in portal.

Please check if it works for your scenario.

Reference: Change log for Power BI Report Server - Power BI | Microsoft Docs

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.