Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. Desktop

Forum Discussion

Gabrielfranco's avatar
Gabrielfranco
Frequent Visitor
7 years ago
Solved

Error by using CTE (WITH)

Earlier this week I started to having problems by using CTE on DirectQuery, as the error below. I didnt identify any syntax erron on the query, even because until last week it was ok. --------...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Gabrielfranco ,

     

    You may take a look at the following posts.

    • https://community.powerbi.com/t5/Desktop/Custom-query-with-CTE-not-supported-bug/m-p/41395#M15659
    • https://community.powerbi.com/t5/Desktop/How-to-DirectQuery-View-with-Recursive-Query-CTE/m-p/408831#M187417
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Gabrielfranco ,

 

You may take a look at the following posts.

  • https://community.powerbi.com/t5/Desktop/Custom-query-with-CTE-not-supported-bug/m-p/41395#M15659
  • https://community.powerbi.com/t5/Desktop/How-to-DirectQuery-View-with-Recursive-Query-CTE/m-p/408831#M187417
Related content
  • Authentication error with Fabric App

    2 months ago
    Aparnaa_MS
  • AI functions with PySpark error

    8 months ago
    Mauro89
  • Issue with Accessing Power BI Admin APIs Using Service Principal (401 Error tryout mode)

    2 months ago
    Venkatesh_
  • Error using DESCRIBE HISTORY on lakehouse with schemas

    1 year ago
    GammaRamma
  • Using Kusto Explorer with Fabric tables

    1 year ago
    smpa01
  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy