Forum Discussion
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...
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
Thanks for the suggestion and links, but I am using strictly Power BI desktop.
Kelly