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
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