Forum Discussion

DataSpace's avatar
DataSpace
Helper II
3 years ago
Solved

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

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

     

  • DataSpace's avatar
    DataSpace
    Helper II
    3 years ago

    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)