Need guidance on migrating power bi reports to databricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2021 09:27 AM
Hi All,
I want to import an existing database/tables (say AdventureWorks) to databricks. And after importing tables, I want to develop reports on top
I need guidance on this. Can someone give me resources that could help me in doing things end to end(fron importing database to developing desired reports)
- Labels:
-
Data Ingestion & connectivity
-
Powerbi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2021 10:57 AM
@sania fatimi There are several different ways to do this and it's really going to depend on what your current need is. You could for example load the data into the databricks delta lake and use the databricks powerbi connecter to query the data from powerbi. You could also stand up a Cloud SQL database and export the data from delta lake to the Cloud SQL DB.