Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Value cannot be null. Parameter Name: name

Hi all,   I am facing issue when am trying to change my live connection to direct query throwing error with below message. Can you please any one help on this? What could be the issue? Thanks in ad...
Show and Tell
V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi ,

 

Live connection loads the whole data model, but direct query is not. This may be caused by chaotic relationships. Please try to uncheck "Autodetect new relationships after data is loaded" in the settings.

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • BSLATTER's avatar
    BSLATTER
    Helper III
    4 years ago

    Hello V-lianl-msft,

     

    I am seeing the same issue as the original poster. When I follow your directions I cannot click in "Current File" -> "Data Load" I get the error in the image below. However I cannot switch it to DQ because I get the same error as poster. Any advise?

     

     

    • daxman's avatar
      daxman
      Advocate II
      4 years ago

      I am seeing the same issue. I suspect it has something to do with the model I am connecting to, it is using parameters to handle Incremental Refresh.

      V-lianl-msftdo you know if there are any limitations of connecting to a model with DirectQuery? I have looked through Microsoft's documentation on this (link), and am not seeing anything related to Parameters other than Parameters not being supported for Server/Database names.

      This appears to be a bug.