How to switch data source from PowerBI dataset (live connection) to Databricks(directQuery)

[DataSpace]

Hi ALL,

An urgent requirement which I am messing up with. If you all can please help:

Need to change data source of existing Power BI report from Power BI Dataset(live connection) to Databricks (DirectQuery Mode).

searched internet but couldn't find relevant one.

I also can not see Power BI dataset connection in Query Editor. where exactly I can find it. I was trying if I can replace those connection with databricks direct query.

Any comment , help is appreciated.

Thanks in Advance

[DataSpace]

Thanks for your reply @Anonymous ,

Yes, seeing no reponse on this post, I had also implemented similar solution:

1. Connected to Databricks and brought the data model into PBI desktop.
2. Deleted the PBI dataset tables from PBI desktop.
3. Renamed the databricks tables/columns to match with existing measures and report(in case if any dicrepancy)
4. ....and its done ( FYI..I have not changed the mode)

[Anonymous · Accepted solution]

Hi @DataSpace 

You cannot change the datesource from PowerBI Dateset to Databricks directly, but you can add the Databricks to the PowerBI desktop after changing the import mode.

Click the 'change the mode' on the lower right corner of Power BI Desktop to change the mode to direct query

Then you can add the new source to Power BI desktop, and you can add the Databricks to the Power BI Desktop first, then delete the orignial datasource to replace it.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.