avikkal89's avatar
avikkal89
Frequent Visitor
8 years ago
Status:
Needs Info

Refresh issues with December Update

Hi Team - I have a PBIX file that refreshed without issues in the Nov release. It throws me an error in the December update. Source Details - -SQL Server DB -Queries contain CTE's -Connected usin...
Reports
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi avikkal89,

 

Based on my test in the latest desktop version 2.53.4954.621 64-bit (December 2017) with CTE query, refresh data without any error occurs. 

 

with CTE(SalesOrderID, UnitPrice,OrderQty)
As (select SalesOrderID, UnitPrice,OrderQty from [Sales].[SalesOrderDetail] where LineTotal IS not NULL)
select SalesOrderID,MAX(UnitPrice) as MaxP, SUM(OrderQty) as TotalQty from CTE
group by SalesOrderID

 

1. Which December desktop version did you run? The latest is 2.53.4954.621 which released yesterday. Please update to this new version. 

 

2. When you refreshed in desktop, which error message threw out? Please show detail error with us. 

 

3. Please create a new simple report, use T-SQL query like above query then test again. 

 

4. When you said Nov version was working, did you install Nov version and December version on the same machine? 

 

Best Regards,
Qiuyun Yu

 

 

Completed Ideas