Forum Discussion

DataSpace's avatar
DataSpace
Icon for Helper II rankHelper 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 ...
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.

     

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.