Forum Discussion

ak77's avatar
ak77
Icon for Post Patron rankPost Patron
2 years ago

Error while Direct Query Option

Hi All,   I am using Direct option while retrieving data from SQL server and gettting below error . but this sql query works perfectly with import mode..  so is there a limitation using direct opti...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ak77 ,

 

Thanks to ExcelMonke  for their replies and allow me to provide another insight:

 

There are a number of potential negatives associated with using DirectQuery. Some of these limitations will vary slightly depending on the exact source you are using. This document lists the general implications of using DirectQuery, as well as limitations related to performance, security, transformations, modelling and reporting.

DirectQuery in Power BI - Power BI | Microsoft Learn

 

In addition, here are solutions to problems similar to yours that we hope will help you:
Solved: Power query loads but errors on close and apply - Microsoft Fabric Community

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

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