Solved: Error Message: Windows authentication is not suppo...

guylyanrd · ‎02-16-2022

Hi team,

I'm having problems connecting to a database. The following error appears:

Feedback Type:
Frown (Error)

Error Message:
Não há suporte para autenticação do Windows no modo DirectQuery para esta fonte de dados (AnalysisServices).

Stack Trace:
Microsoft.PowerBI.Client.Windows.AnalysisServices.DirectQueryWindowsAuthNotSupportedException
   em System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
   em System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
   em System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
   em Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
   em Microsoft.PowerBI.Client.Windows.LiveConnectHelpers.LiveConnectionPropertiesValidator.TryGetValidLiveConnectionProperties(IPowerBIWindowService windowService, ILiveConnectionProperties connectionProperties, Report report, ILiveConnectionCompleter liveConnectionPropertiesCompleter, ILiveConnectionProperties& validLiveConnectionProperties, Boolean& resultIsSameConnection, ValidationStatus& validationStatus)
   em Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.AreAnalysisServicesConnectionPropertiesValid(IPowerBIWindowService windowService, Report report, ILiveConnectionProperties connectionProperties, AnalysisServicesConnectionMode connectionMode, ILiveConnectionCompleter completer, ILiveConnectionProperties& validConnectionProperties)
   em Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.ValidateAndCreateAnalysisServicesConnection(ILiveConnectionProperties connectionProperties, Boolean addToFormulaHistory)
   em Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.TryImportAnalysisServiceLiveConnection(JsonUpdate builderResults, Query query)
   em Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.OnQuerySettingsResolved(JsonUpdate builderResults, Query query, String sourceId, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor)
   em Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass63_0.<ResolveQuerySettings>b__0(JsonUpdate builderResults, Formula updatedFormula)
   em Microsoft.Mashup.Client.UI.Shared.DataImporter.ShowBuilderDialog(PackageReference packageReference, FormulaPath formulaPath, FormulaPartInfo formulaPartInfo, Query query, Action`2 successCallback, Action failureCallback, Boolean isNewQuery, Boolean isFromEditor)
   em Microsoft.Mashup.Client.UI.Shared.DataImporter.ResolveQuerySettings(Query query, Action`2 successCallback, Action failureCallback, ResolutionSetting resolutionSetting, Boolean isNewQuery, Boolean isFromEditor)
   em Microsoft.Mashup.Client.UI.Shared.DataImporter.ResolveQuerySettings(Query query, SourceFormula addedFormula, Boolean isNewQuery, Boolean isFromEditor)
   em Microsoft.Mashup.Client.UI.Shared.DataImporter.TryAddSource(String sourceID, Nullable`1 targetQueryGroupId, Query& newQuery)
   em Microsoft.PowerBI.Client.Windows.PowerBIDataImporter.TryAddSource(String sourceID, Nullable`1 targetQueryGroupId, Query& newQuery)
   em Microsoft.Mashup.Client.UI.Shared.ConnectHelper.Connect(IWindowHandle owner, IDataSourceTemplateProvider dataSourceTemplateProvider, IUIHost uiHost, ITelemetryService telemetryService, DataImporter dataImporter, CommandUIControlBase commandUIControl, String sourceId, Nullable`1 targetQueryGroupId)
   em Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.<Connect>d__45.MoveNext()
--- Fim do rastreamento de pilha do local anterior onde a exceção foi gerada ---
   em System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   em System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

Stack Trace Message:
Não há suporte para autenticação do Windows no modo DirectQuery para esta fonte de dados (AnalysisServices).

Invocation Stack Trace:
   em Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   em Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
   em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
   em Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
   em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
   em Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
   em Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
   em Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
   em System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
   em Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)
   em Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
   em Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)
   em Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<ExecuteCore>d__14.MoveNext()
   em System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   em Microsoft.PowerBI.Client.Windows.CommandStoreHostService.ExecuteCore(String commandId, String parameterJson, Int64 promiseHandle)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
   em System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
   em System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
   em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   em System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   em System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   em System.Delegate.DynamicInvokeImpl(Object[] args)
   em System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   em System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   em System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   em System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   em System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   em System.Windows.Forms.Control.InvokeMarshaledCallbacks()
   em System.Windows.Forms.Control.WndProc(Message& m)
   em System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   em System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
   em System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
   em System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   em System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   em System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
   em Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
   em Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__2()
   em Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
   em Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   em Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.100.1401.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Services.UIBlockingService","Error":"Microsoft.PowerBI.Client.Windows.AnalysisServices.DirectQueryWindowsAuthNotSupportedException","MethodDef":"AllowModalDialogs","ErrorOffset":"43"}

Snapshot Trace Logs:
C:\Users\876338\Microsoft\Power BI Desktop Store App\FrownSnapShotf6201dbc-df85-40c0-819e-9179d3584c5e.zip

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\876338\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_qnaLiveConnect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enableWebView2
PBI_sparklines

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_useModernFormatPane
PBI_scorecardVisual

Enabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBIUserFeedbackServices_IsReported:
True

Formulas:


section Section1;

shared #"DirectQuery para AS – SSAS-CORPORATIVO" = let
    Source = AnalysisServices.Database("asazure://brazilsouth.asazure.windows.net/analysisservices1", "SSAS-CORPORATIVO"),
    Cubes = Table.Combine(Source[Data]),
    Cube = Cubes{[Id="Model", Kind="Cube"]}[Data]
in
    Cube;

shared WhatsApp = let
    Fonte = Excel.Workbook(File.Contents("file://nt999-02/comuns$\\Orcamentos\MIS\Power BI\2. Bases Gateway\Vendas WhatsApp.xlsx"), null, true),
    #"BASE PBI_Sheet" = Fonte{[Item="BASE PBI",Kind="Sheet"]}[Data],
    #"Cabeçalhos Promovidos" = Table.PromoteHeaders(#"BASE PBI_Sheet", [PromoteAllScalars=true]),
    #"Colunas Removidas" = Table.RemoveColumns(#"Cabeçalhos Promovidos",{"TOTAL", "MÊS", "ANO"}),
    #"Colunas Renomeadas" = Table.RenameColumns(#"Colunas Removidas",{{"VESTUÁRIO", "VESTUARIO"}}),
    #"Tipo Alterado" = Table.TransformColumnTypes(#"Colunas Renomeadas",{{"Cód Loja ", Int64.Type}, {"Loja ", type text}, {"Regional ", type text}, {"DATA", type date}, {"LAR", type number}, {"VESTUARIO", type number}, {"ELETRO", type number}}),
    #"Colunas Não Dinâmicas" = Table.UnpivotOtherColumns(#"Tipo Alterado", {"Cód Loja ", "Loja ", "Regional ", "DATA"}, "Atributo", "Valor"),
    #"Colunas Renomeadas1" = Table.RenameColumns(#"Colunas Não Dinâmicas",{{"Atributo", "Departamento"}})
in
    #"Colunas Renomeadas1";

shared _medidasLY = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared _medidasYTD = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared #"_medidas%" = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared _medidasTXT = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}})
in
    #"Tipo Alterado";

shared _medidasComparativas = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared #"SSS teste" = let
    Fonte = Excel.Workbook(File.Contents("file://nt999-02/comuns$\\Orcamentos\MIS\Power BI\2. Bases Gateway\SSS provisório - Figital.xlsx"), null, true),
    #"SSS teste_Sheet" = Fonte{[Item="SSS teste",Kind="Sheet"]}[Data],
    #"Cabeçalhos Promovidos" = Table.PromoteHeaders(#"SSS teste_Sheet", [PromoteAllScalars=true]),
    #"Tipo Alterado" = Table.TransformColumnTypes(#"Cabeçalhos Promovidos",{{"Loja COD", Int64.Type}, {"Loja DESC", type text}, {"DT_INAUGURAÇÃO", type datetime}, {"Perfil", type text}, {"Column5", Int64.Type}})
in
    #"Tipo Alterado";

shared dIndice = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXLLTM8sScxRitWJVjIC8oMTk/NzEsFcYyDXubQgPxfMMwHxcjILS1MVUhWCUksyi1LB4qZA8ZDEpJzUEjDXDMgNz0gsKXYsKFCKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Cód." = _t, Produto = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Cód.", Int64.Type}, {"Produto", type text}}),
    #"Linhas Principais Removidas" = Table.Skip(#"Tipo Alterado",1)
in
    #"Linhas Principais Removidas";

shared _MedidasFigital = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared _MedidasCliqueRetire = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared #"dbMeta e Atingimento" = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}}),
    #"Colunas Removidas" = Table.RemoveColumns(#"Tipo Alterado",{"Coluna 1"})
in
    #"Colunas Removidas";

shared _medidasEcommerce = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}})
in
    #"Tipo Alterado";

shared #"Receita Bruta Ajustada" = let
    Fonte = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Coluna 1" = _t]),
    #"Tipo Alterado" = Table.TransformColumnTypes(Fonte,{{"Coluna 1", type text}})
in
    #"Tipo Alterado";

shared TAB_BASELOJAS = let
    Fonte = Excel.Workbook(File.Contents("file://nt999-02/comuns$\\Orcamentos\MIS\Power BI\2. Bases Gateway\BASE_LOJAS.xlsx"), null, true),
    TAB_BASELOJAS_Table = Fonte{[Item="TAB_BASELOJAS",Kind="Table"]}[Data],
    #"Tipo Alterado" = Table.TransformColumnTypes(TAB_BASELOJAS_Table,{{"COD", Int64.Type}, {"KEY", Int64.Type}, {"LATITUDE", type number}, {"LONGITUDE", type number}, {"GPS", type text}, {"LOJA", type text}, {"INAUGURADA", type text}, {"PORTE", type text}, {"SHOP/RUA", type text}, {"ADMINISTRADORA", type text}, {"BASE", Int64.Type}, {"INAUGURAÇÃO", type date}, {"ANIV. CIDADE", type any}, {"POPULAÇÃO", Int64.Type}, {"M2 Vestuário", type number}, {"M2 Lar", type number}, {"M2 Eletroleve", type number}, {"M2 RM", type number}, {"M2 Vendas", type number}, {"M2 Total", type number}, {"GGL", Int64.Type}, {"GERENTE DE GRUPO", type text}, {"AREA ATUAÇÃO", type text}, {"DIRETOR VENDAS", Int64.Type}, {"NOME DIR VENDAS", type text}, {"CHAPA GERENTE ", Int64.Type}, {"NOME DO GERENTE", type text}, {"REGIÃO", type text}, {"CIDADE", type text}, {"UF", type text}, {"ENDEREÇO", type text}, {"BAIRRO", type text}, {"CEP", type text}, {"DDD", Int64.Type}, {"TELEFONE 1", type text}, {"CNPJ", type text}, {"INSCRIÇÃO ESTADUAL", type any}})
in
    #"Tipo Alterado";

shared SECOES = let
    Fonte = Excel.Workbook(File.Contents("file://nt999-02/comuns$\\Orcamentos\MIS\Power BI\2. Bases Gateway\BASE_LOJAS.xlsx"), null, true),
    SECOES_Sheet = Fonte{[Item="SECOES",Kind="Sheet"]}[Data],
    #"Tipo Alterado" = Table.TransformColumnTypes(SECOES_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type text}}),
    #"Cabeçalhos Promovidos" = Table.PromoteHeaders(#"Tipo Alterado", [PromoteAllScalars=true]),
    #"Tipo Alterado1" = Table.TransformColumnTypes(#"Cabeçalhos Promovidos",{{"Departamento Codigo", type text}, {"Departamento Descrição", type text}, {"Secao Codigo", type text}, {"Secao Descricao", type text}, {"Mundos", type text}})
in
    #"Tipo Alterado1";

I have full permissions with the db, but I still can't connect.

I'm from Brazil, so there may be some information in Portuguese in the middle of the error...

Anonymous · ‎02-20-2022

HI @guylyanrd,

As the error message said, it seems like the Datasource(AnalysisServices) does not support using direct query mode with windows authorization.

Did you work with the 'direct query' preview feature to connect to your data source? If that's the case, it should be a limitation of feature usage.

You can take a look at the following link to know more about these:

Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs

Spoiler

Using any of the following sources as a DirectQuery source is not supported:
- SQL Server Analysis Services (SSAS)
- SAP HANA
- SAP Business Warehouse
- Real-time datasets
- Sample Datasets
- Excel Online Refresh
- Import Excel / CSV files
- Content Packs (deprecated)
- Usage Metrics (classic workspaces)

Using any of the following sources as a DirectQuery source is not supported: SQL Server Analysis Services (SSAS) SAP HANA SAP Business Warehouse Real-time datasets Sample Datasets Excel Online Refresh Import Excel / CSV files Content Packs (deprecated) Usage Metrics (classic workspaces)

Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎02-20-2022