Forum Discussion

aviperez254's avatar
aviperez254
Copper Contributor
Nov 17, 2023

Regression/Bug in MSOLAP OLEDB drivers 2022 for Power BI Workspaces

[I hope this is the right forum to post the issue:]

 

We have seen a recurring authentication problem when using the MSOLAP OLEDB drivers (v2022, 16.0.xx.xx) connecting to Power BI Workspaces. The connection breaks after a few minutes, before becoming operational again a few minutes later (and this behavior repeats from there). We believe it relates to the change in the auth mechanism made in the latest driver versions (with Entra ID). If we retro the drivers to the "2018" version, the problem does not appear. We think its related to expired tokens not being refreshed automatically by the driver. Outside of that, the drivers work well on all older SSAS technologies.

 

Here is the error thrown (not English):

Fel uppstod i OLE DB-providern. Det går inte att hämta autentiseringstoken med hjälp av de angivna autentiseringsuppgifterna. Ange tomma värden i fälten Användarnamn och Lösenord om din Active Directory-innehavaradministratör har konfigurerat Multi-Factor Authentication eller om ditt konto är ett Microsoft-konto, och försök sedan på nytt. Du lär sedan uppmanas att ange dina autentiseringsuppgifter. at server powerbi://api.powerbi.com/v1.0/myorg/Supply%20Chain%20Analysis, using connection string Provider=MSOLAP;Data Source=powerbi://api.powerbi.com/v1.0/myorg/Supply%20Chain%20Analysis;

 

Possibly relevant info:

The problem seems to happen primarily if the calls are made from a C# "client" app running as a Windows service (with admin privileges etc).  It is not OS specific (it happens on different versions of Windows). 

 

The Power BI instance we have been connecting:

Service Version: 13.0.22007.81

Client Version: 2311.1.16680-train

 

No RepliesBe the first to reply

Resources