Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
pauline3838
Regular Visitor

error message with gateway

Hello, i have this error message when i try to launch my .pbix dashboard. I use a gateway to connect Power BI Desktop with a external database. Someone can help me to understand this issue ?

Thnaks

 

 

Error message: No other credentials for Windows authentication are supported in DirectQuery mode. Use your current Windows credentials, provide credentials for the database, or switch to import mode.

 

 

Feedback Type:
Frown (Error)

Timestamp:
2020-06-08T13:19:59.9249348Z

Local Time:
2020-06-08T15:19:59.9249348+02:00

Session ID:
7e3eaffb-be31-4e18-957a-75dd9706c3cb

Release:
April, 2020

Product Version:
2.80.5803.1061 (20.04) (x64)

Stack Trace:
à Microsoft.PowerBI.Client.Windows.AnalysisServices.DirectQueryConnectionStringBuilder.AddCredential(ResourceCredentialCollection credentialCollection, String globalPipe)
à Microsoft.PowerBI.Client.Windows.AnalysisServices.PersistedModelSanitizer.AddCredentialsToConnectionStringBuilder(CredentialManager credentialManager, DirectQueryConnectionStringBuilder connectionStringBuilder, Boolean isV3Model)
à Microsoft.PowerBI.Client.Windows.AnalysisServices.PersistedModelSanitizer.ApplyCredentialsToDataSource(CredentialManager credentialManager, IDataSource dataSource, ModelChange modelChange, Boolean isV3Model)
à Microsoft.PowerBI.Client.Windows.AnalysisServices.PersistedModelSanitizer.TryRestoreModel(IDataModel dataModel, ModelChange& modelChange)
à Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesDatabaseLocal.BuildActionToRestoreConnectionStringCredentials(Action& restoreCredentialsAction)
à Microsoft.PowerBI.Client.Windows.AnalysisServices.PersistedModelHelpers.PromptAndRestoreCredentials(Report report, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IUIHost uiHost, IQueryServices queryServices, IEventAggregationService eventAggregationService)
à Microsoft.PowerBI.Client.Windows.MainWindow.<<OnMainWindowInitializationCompleted>b__204_2>d.MoveNext()
--- Fin de la trace de la pile à partir de l'emplacement précédent au niveau duquel l'exception a été levée ---
à System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
à System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
à Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.80.5803.1061","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.AnalysisServices.DirectQueryConnectionStringBuilder","Error":"Microsoft.PowerBI.Client.Windows.AnalysisServices.DirectQueryConnectionStringBuilderException","MethodDef":"AddCredential","ErrorOffset":"418"}

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 fr-FR)

CLR Version:
4.5 or later [Release Number = 378389]

Peak Virtual Memory:
4.36 GB

Private Memory:
439 MB

Peak Working Set:
718 MB

IE Version:
11.0.9600.19301

User ID:
e91e3642-f8dc-41e7-86a0-10393f27d5dc

Workbook Package Info:
1* - fr-FR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\onyxbi\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1154071509.zip

Model Default Mode:
DirectQuery

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
False

Enabled Preview Features:
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_hierarchicalSlicerCreation

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_inlineExplore
PBI_realTimeRefresh
PBI_v3ModelsPreview
PBI_decompositionTree
PBI_relativeTimeSlicer

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

2 REPLIES 2
aj1973
Community Champion
Community Champion

Hi @pauline3838 

The Power Bi Desktop doesn't need the Gateway to connect to the source. The Power Bi desktop has its own connector

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Tahreem24
Super User
Super User

@pauline3838 ,

Kindly refer the below thread:

https://community.powerbi.com/t5/Desktop/Direct-Query-On-SQL-Server-on-Windows-Authentication/m-p/32...

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.