databricks as datasource for report buider paginated reports

[Anonymous]

Hi,

I need to get data from databricks data base to report buider paginated report

any idea?

thanks in advance

[harshnathani]

Hi @Anonymous ,

See if the below links help.

https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/power-bi#:~:text=Launch%20Power%20BI%20Desktop%2C%20click,dialog%2C%20configure%20your%20cluster%20connection.

https://towardsdatascience.com/visualizing-data-with-azure-databricks-and-power-bi-desktop-845b0e317dc6

https://www.youtube.com/watch?v=JJfjI3stnsA

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

[Anonymous]

thanks for your response but it works only for power bi desktop not for report builder

I need to create paginated reports using report builder and databricks as data source.

I don't think it's possible to create paginated reports in power bi desktop

[V-lianl-msft]

Hi @Anonymous ,

Refer to :

https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-create-embedded-dataset 

You can also try to use the desktop connect to the databricks and then publish to the service, and then connect to shared dataset.

https://docs.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets 

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