Forum Discussion
PowerBI dataflow refresh failed due to Premium_ASWL_Error
Hi all,
In my case, I have two PBI dataflows with some tables. I want to created a new table in dataflow A with two table, one is from dataflow A the other one is from dataflow B, the transformation has done and the preview works well. But when I save and refresh it later, it will be failed with the error : {"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."}}],"exceptionCulp....
I remembered I had do the same action before and without any issue, so if these have any change for PBI dataflow or anyone can help me on this?
Thanks advance,
Elva
Hi ElvaHuang
I found a similar case , maybe you can refer to it .
Advice when using a DirectQuery and dataflow toget... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi ElvaHuang
I found a similar case , maybe you can refer to it .
Advice when using a DirectQuery and dataflow toget... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.If you use the CLENDARAUTO CALENDARAUTO function (DAX) - DAX | Microsoft Learn "Returns a table with a single column named "Date" that contains a contiguous set of dates. The range of dates is calculated automatically based on data in the model."
The calculated table is effectively based on the DQ source and is not supported to refresh in the service.
Please consider using the CALENDAR function instead. Corresponding document:CALENDAR function (DAX) - DAX | Microsoft Learn