Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Teradata Direct Query Error

I'm able to run the below query in TD SQL Assistant.  I am using ORDER BY because my understanding is that will improve the PowerBI performance.   SELECT TPO_SKU_PRD_SLS_SUMMRY.TPO_SKU, TPO_SKU_PR...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , I can be a database level issue. Some database do not allow order by in subquery. In this case of you need to give order by in the outer query. Also, you are not using any limit, so I doubt order by will benefit

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

This is not a database issue as I can execute it in Excel Power Query/PowerPivot and pull all the data.  However, when I try and do the same in PowerBI, the query fails.  I was able to load ~1.7 Million rows into Excel Power Pivot

 

Thought Power Query is supposed to be the same between Excel and Power BI? 

 

Thanks

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    I suppose this should be related to power bi service security. AFAIK, some types of data sources, functions, and requests/operations will be blocked due to security reasons.

    Power BI Security#data-storage-security 
    According to your error message, I think it means 'order by' function not allowed to use in t-SQL subquery when they executed on power bi service side. You can try to remove it or switch to other equivalent functions and try again.

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for the suggestion and links, but I am using strictly Power BI desktop.

      Kelly