PowerBI Web Publish Issue

[Heisenstein]

Hello,

PowerBI newbie here. I've created a DirectQuery connection to Azure Databricks in my desktop, then I published the report to the PowerBI Web workspace. However, when I open the dashboard in my PowerBI Web workspace, I'm prompted with the following error message:

The report is there on PowerBI Web, but when I open it or refresh the data, this is what I get. I've tried going through numerous documentation, but to no avail. I'd appreciate any guidance possible. 

Thanks!

[GilbertQ · Accepted solution]

Hi @Heisenstein 

A limitation of Publish to web is that DirectQuery is not supported.

More details are here: Publish to web from Power BI - Power BI | Microsoft Docs

[Heisenstein]

Hi @GilbertQ, if I change the data import mode to Import, will the data in PowerBI Web Service still be able to refresh as the dataset in Databricks changes? I read the documentation and it mentioned the data will refresh not from PowerBI desktop, but from the database server. But just want to confirm it works for PowerBI Web Service using Import. I'd appreciate any help.

[GilbertQ · Accepted solution]

Hi @Heisenstein 

Yes you can import the data and then refresh from databricks, that will certainly work.

[Heisenstein]

Thanks very much, I appreciate your quick responses 🙂 

[GilbertQ]

Thanks for letting us know!

[GilbertQ · Accepted solution]

Hi @Heisenstein 

A limitation of Publish to web is that DirectQuery is not supported.

More details are here: Publish to web from Power BI - Power BI | Microsoft Docs