Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

BRNS

SCHEDULED REFRESH ERROR WHEN USING DATASET CONNECTION

Submitted by on ‎01-12-2023 02:53 AM

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

Hi @BRNS 

It sounds like you are trying to refresh a Power BI dataset that includes a calculated table that depends on another table that uses Direct Query mode to connect to an Analysis Services data source. Unfortunately, Power BI does not currently support refreshing datasets that include calculated tables that depend on tables using Direct Query mode.

One solution you could consider is to change the source data for the calculated table so that it does not use Direct Query mode. This would allow you to refresh the dataset, but you would need to find a way to incorporate the data from the Direct Query source into the calculated table using other means, such as using Power Query to merge or append the data.

Another option is to use a separate dataset for the calculated table, and then use a measure or a report-level filter to control the data displayed in the report based on the data in the calculated table. This would allow you to refresh the main dataset without affecting the calculated table.

It's also worth noting that Power BI recently introduced the ability to refresh datasets that include calculated columns, so you may want to consider using calculated columns instead of a calculated table if that meets your needs.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
13 Comments (13 New)
Comments
MarkHerman
New Member
‎05-01-2024 06:28 AM

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
‎08-29-2024 09:00 AM

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

jtao
Helper I
Helper I
‎08-29-2024 07:29 PM

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

Idea Statuses