Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
Hi @Heisenstein
Yes you can import the data and then refresh from databricks, that will certainly work.
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.
Hi @Heisenstein
Yes you can import the data and then refresh from databricks, that will certainly work.
Thanks very much, I appreciate your quick responses 🙂
Thanks for letting us know!
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