Forum Discussion
lovishsood1
Resolver I
Resolver INot 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...
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
AndyDDC
Most Valuable Professional
Most Valuable ProfessionalCan you post the whole SQL script you're using the create the view? eg
create view dbo.vwGetData
AS
with datav3
AS
(
select * from fact_sales
)
select * from datav3
lovishsood1Resolver I
Resolver IThis is the entire script.