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: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

0
Haripinnoju

Issue with the Power BI Scheduled Refresh

Submitted by on ‎07-20-2023 11:22 PM

I have got an error at Scheduled Refresh stating that " Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery". I have been using a Composite Model connecting to two CIM cubes, one source from datalake (datalake tables). I have been using three sources to create the calculated tables as I need to filter the correct data and do some calculations. 

When I was using two CIM Cubes into Power BI and a SharePoint and created the calculated tables using that and performed a Scheduled Refresh for the previous dashboards, I did not face any issue  in the Refresh, whereas I additionally connected with the ADW backend tables directly into the Power BI now and creating the calculated tables performing the composite using direct query, is there any problem as I see this error.

Please help!
Thank you

Status: Delivered
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎07-24-2023 02:38 AM

Hi  @Haripinnoju ,

 

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_Caitlyn

Idea Statuses