Forum Discussion
DirectQuery for power bi datasets and AS error: Query can only go through 2 levels
Hi Everyone, I have an urgent problem that caused my dashboard to stop working and possibly broke my dataset that had incremental refresh applied and was collectiing data for many months... I had...
Hi Anonymous ,
You cannot revert the data model from Analysis Services to SQL due to inconsistent data sources.
I have a few questions about "report not working", is the report not opening or refreshing, what are the details of the error, and is the gateway configured correctly for the data source.
You can try turning this setting on in Desktop.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.