Akshaya V on 21 Jun 2023 09:03:32
Due to limitations in the "Publish to Web" feature, we cannot publish a report to the web if it uses a direct query.
Publish to web from Power BI - Power BI | Microsoft Learn
Single sign-on data query models, including composite models on Power BI datasets or Azure Analysis Services.
It would be great if this limitation was lifted for the Publish to Web feature.