Forum Discussion
Refreshes for Datasets containing Calculated Tables over Direct Query to AS started failing Mar 30th
Hello, Refreshes of datasets that contain calculated tables from DQ to AS started failing March 30th, 2022. This worked completely fine until March 29th which points to a change at Power BI service...
Solved this - randomly got the error on multiple reports that use SQL server on refresh.
In the data source credentials - I unselected the 'reviewers can access this data source with their own PBI identities in DQ'
and signed in again with SSO authorisation.
Th
Had to sign in a few times for this to work - but worked, and didn't have to change any calculated columns