Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
Kindly refer the below thread:
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
Kindly refer the below thread:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |