Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

SCHEDULED REFRESH ERROR WHEN USING DATASET CONNECTION

Data source error: {"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery."}}],"exceptionCulprit":1}}}
Cluster URI: WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net
Activity ID: 954fd614-029c-451f-ab77-aac648a599e3
Request ID: 02fb20e5-43e4-376e-ccc8-b07440f335f0
Time: 2023-01-12 10:31:06Z

Status: Investigating
Comments
MarkHerman
New Member

Please let us know when this issue is addressed. Strangely enough, I can write the same DAX query in a paginated report without a problem. 

dannyfig
Frequent Visitor

@jtao did you solve your problem? I'm facing the same issue...

jtao
Helper I

I don't think it has been resolved. It may still require to remove the calculated tables.

This widget could not be displayed.