Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi @venuswang
The issue has been fixed. Please have a check.
Best Regards,
Community Support Team _ Ailsa Tao
Hi @chang_B
It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.
Best Regards,
Community Support Team _ Ailsa Tao
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
Existing ICM for similar issue(ICM 297756751). It should be a new known issue that dataflow refresh taking long times that usual to complete. Employee engages this issue as well.
Hi all ,
We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient ! Thank you for your cooperation !
Best Regards,
Community Support Team _ Ailsa Tao
HI all,
This issue has been fixed , please check it in your Service .
Best Regards,
Community Support Team _ Ailsa Tao
Hi @AHeyman_
This issue has been fixed , Please check it in your broswer .
Best Regards,
Community Support Team _ Ailsa Tao