cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Loading PowerBi report in databricks..

thisisadarshsin
New Contributor II

Hi ,

I am trying to load power bi report in databricks,but i am getting..empty while printing report.. i have already installed pip install powerbiclient,and device_auth is also successfull,but

report = Report(group_id=group_id, report_id=report_id, auth=device_auth)

report

i have also embedded my report..in https://playground.powerbi.com/ it is woking fine there,but in datbricks getting empty

report

image.pngimage

2 REPLIES 2

Anonymous
Not applicable

@Adarsh Singhโ€‹ :

It seems like you have successfully authenticated and created a report object using the powerbiclient library. However, it's not clear how you are trying to load and display the report in Databricks.

Here are a few things you can try to troubleshoot the issue:

  1. Make sure that the report is actually returning data by calling the report.render() method. This should return a dictionary containing the report's content.
  2. Check that you have the necessary privileges to access the report from Databricks.
  3. Verify that the group_id and report_id are correct and that the report exists in the Power BI group.
  4. If you are using the displayHTML function to display the report, make sure that the HTML content is properly formatted and includes the necessary JavaScript and CSS files.
  5. Try using a different method to display the report, such as exporting the report as a PDF or an image and then displaying it in Databricks using the display function.

Hopefully, one of these suggestions will help you identify the issue and get your Power BI report to display correctly in Databricks.

Anonymous
Not applicable

Hi @Adarsh Singhโ€‹ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group