Forum Discussion

mwhitehead's avatar
mwhitehead
Icon for Microsoft Employee rankMicrosoft 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 fo...
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

collinq's avatar
collinq
Icon for Super User rankSuper 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

mwhitehead's avatar
mwhitehead
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

CLo Clearning the permissions worked. Thank you!