question

abhishek6555 avatar image
0 Votes"
abhishek6555 asked PRADEEPCHEEKATLA-MSFT commented

Difference connecting directly to databricks workspace vs SQL Analytics workspace using Power BI

Hi,

Wanted some good document links on what will be the advantages/disadvantages of connecting directly to data bricks workspace using Power BI to access datalake sources against connecting the same using SQL analytics workspace.

Please suggest.

Thanks

azure-databricks
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @abhishek6555,

Thanks for the question and using MS Q&A platform.

Currently, I didn’t find any document that discuss the pros/cons of either connection scenario, however some points as things currently stand:

  • SQL Analytics (now Databricks SQL) is still in preview - so any connection from PBI to DSQL should bear that in mind from a dev/test/prod perspective.

  • DSQL supports Photon (which is also experimental ATM) - Workspace Databricks is also getting Photon - but isn't there yet.

  • The actual JDBC/ODBC connector is the same .

Hope this helps. Do let us know if you any further queries.


Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @abhishek6555,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @abhishek6555,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Take care & stay safe!


Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

0 Votes 0 ·
DSPatrick avatar image
0 Votes"
DSPatrick answered

The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.