Forum Discussion

lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
2 years ago
Solved

Not able to save CTE as Table or View

Hello Everyone,   I have created a CTE as follows;   WITH cte as ( SELECT Month_Name, Month_Number, Project_Category, 100.0 * Actual_Hours / NULLIF(SUM(A...
Data Integration
Data Science
data warehouse
one lake
power bi
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    I think this is now a Power BI issue rather than a Synapse issue. You will be better served posting this logic issue in the Power BI forum

lovishsood1's avatar
lovishsood1
Icon for Resolver I rankResolver I
2 years ago

Hi,

 

Thank you the reply.

 

But Output is perfectly being shown. 
Problem is coming when I try to save the OUTPUT as VIEW of Save it as the table.

 

 

AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

if you want to create a view, just put the following syntax before your WITH statement:

 

CREATE VIEW dbo.viewname 

AS

WITH...