Direct Query on Power BI Dataset not working anymore

[Matthieu_Mamet]

Hi everyone, 

The Direct Query feature on Power BI has been released as a preview feature for a few months now and we have been using it a lot with my team. 

But since last week, we have this error that is frown and we are not able to use this feature anymore.

Feedback Type:
Frown (Error)

Error Message:
The remote server returned an error: (400) Bad Request.

Technical Details:
RootActivityId: f11fb14d-f7df-4733-b4c6-5c13fcd80de9

Our Data Center : North Europe (Ireland)

What is even more weird is that the functionnality is still working on other tenants in other data centers. Maybe juste an update of this Azure Data Center ? 

Has any of you found the same error message ? 

[Anonymous]

Hi @Matthieu_Mamet,

I am not aware of any known issues like this recently. Check that the relevant settings in your "admin portal" are enabled to ensure that they are not disabled by the administrator.

Next, refer to the following document for considerations and restrictions when using the DQ schema for datasets and the associated tenant restrictions.

Using DirectQuery for datasets and Analysis Services (preview) - Power BI | Microsoft Learn

All information as above can be found at this link.

Best regards,

Community Support Team Selina zhu