Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
RosanyA
Frequent Visitor

Unable to download report with databricks live connection in PBI service

Hi all,

 

Two of us are working on the same dashboard and when we both make edits, we would like to download the dashboard with live connection to data in databricks, make edits then republish.

 

My colleague created the report and databricks connection and is able to download the report with the live connection. However, I'm not able to. I can only download the report, then connect to the power bi dataset. This however isn't ideal as we would like to keep the live connection.

 

My colleague has connected to databricks via the Azure Databricks connector, and enters their server hostname and HTTP path. Is the reason I can't download report with live connection due to the server hostname and HTTP path? is that specific to the user?

1 REPLY 1
ibarrau
Super User
Super User

Hi there. I'm not sure what you mean here because you can't do live connection to databricks. That only works for Analysis Services or PowerBi Dataset data source.

I would say that if you only need to work on visual reports, then it's ok to download a report that only will connect to the dataset and not the databricks directly. That way you won't duplicated the data model, you are only using one.

Now, if you want to download the data model to modify the ETL getting data from databricks, then it's a problem.

In order to work with somebody I wouldn't recommend download pbix. I would keep the original pbix at a repository like sharepoint or github. That way you always pull the last version of pbix from repo to keep everything up to date when you publish regarding changes.

Be aware to check the limitations for downloading pbix, because there might be something there that is not allowing what you want: https://learn.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#limitations

I hope that helps,


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

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors