Forum Discussion

mwhitehead's avatar
mwhitehead
Microsoft Employee
2 years ago
Solved

Issue with linking to data

I keep getting the same error message when I try to connect to the server for the CxE Cube database. How can I resolve this issue?

 

Windows authentication isn't supported in DirectQuery mode for this data source (AnalysisServices). True
Need Help
  • collinq's avatar
    collinq
    2 years ago

    Hi mwhitehead ,

     

    I think the easiest way would be to switch to "import" mode.  But, if you need to use "Direct Query" then try either Database credential or perhaps "Microsoft Account".

     

    If it WAS working but is not now, then try clearing the permissions under the Data Source Settings - Edit Datasource

2 Replies

  • collinq's avatar
    collinq
    Super User
    2 years ago

    Hi mwhitehead ,

     

    I think the easiest way would be to switch to "import" mode.  But, if you need to use "Direct Query" then try either Database credential or perhaps "Microsoft Account".

     

    If it WAS working but is not now, then try clearing the permissions under the Data Source Settings - Edit Datasource