Error : Power BI connectivity to Azure data bricks table with parquete file in Azure data lake gen2

[avinash_gatty]

Hi, I am trying to read data from Azure data bricks. The Azure data bricks table that I have is external table with parquete file in Azure Data Lake Gen2. I am using the instruction from "https://docs.azuredatabricks.net/user-guide/bi/power-bi.html" page to connect Power BI to Azure data bricks One I complete step, I do see the PowerBI able to read the table schema. However, it fails to read the data and getting below error Can you please look in to this at the earliest as we have major producction release planned. 

Feedback Type:
Frown (Error)

Timestamp:
2019-02-21T10:08:29.7733550Z

Local Time:
2019-02-21T15:38:29.7733550+05:30

Session ID:
4668fcef-b123-4b80-a7f2-4b25f8891b9e

Release:
November 2018

Product Version:
2.64.5285.741 (18.11) (x64)

Error Message:
OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'com.google.common.util.concurrent.UncheckedExecutionException: com.databricks.backend.daemon.data.common.InvalidMountException: Error while using path /mnt/smdp/publish/product/Sprinklr/DimAllocadiaCampaign/full for resolving path '/publish/product/Sprinklr/DimAllocadiaCampaign/full' within mount at '/mnt/smdp'.'..

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461814]

Peak Virtual Memory:
38.2 GB

Private Memory:
383 MB

Peak Working Set:
561 MB

IE Version:
11.253.17763.0

User ID:
5a159f05-9fee-4645-a89e-484c9929cbf0

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\avingatt\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot258521695.zip

Performance Trace Logs:
C:\Users\avingatt\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
MSIT

DPI Scale:
150%

Supported Services:
Power BI

Formulas:

section Section1;

shared #"sprinklrproduction dimallocadiacampaign" = let
    Source = ApacheSpark.Tables("https://westus2.azuredatabricks.net:443/sql/protocolv1/o/5701963395210664/1217-051243-moos31", 2),
    sprinklrproduction_dimallocadiacampaign = Source{[Schema="sprinklrproduction",Item="dimallocadiacampaign"]}[Data]
in
    sprinklrproduction_dimallocadiacampaign;

shared #"sprinklrproduction dimsprinklraccount" = let
    Source = ApacheSpark.Tables("https://westus2.azuredatabricks.net:443/sql/protocolv1/o/5701963395210664/1217-051243-moos31", 2),
    sprinklrproduction_dimsprinklraccount = Source{[Schema="sprinklrproduction",Item="dimsprinklraccount"]}[Data]
in
    sprinklrproduction_dimsprinklraccount;

shared #"sprinklrproduction dimsprinklrpost" = let
    Source = ApacheSpark.Tables("https://westus2.azuredatabricks.net:443/sql/protocolv1/o/5701963395210664/1217-051243-moos31", 2),
    sprinklrproduction_dimsprinklrpost = Source{[Schema="sprinklrproduction",Item="dimsprinklrpost"]}[Data]
in
    sprinklrproduction_dimsprinklrpost;

shared #"sprinklrproduction factsprinklrpost" = let
    Source = ApacheSpark.Tables("https://westus2.azuredatabricks.net:443/sql/protocolv1/o/5701963395210664/1217-051243-moos31", 2),
    sprinklrproduction_factsprinklrpost = Source{[Schema="sprinklrproduction",Item="factsprinklrpost"]}[Data]
in
    sprinklrproduction_factsprinklrpost;

shared #"sprinklrproduction factsprinklrpostsummary" = let
    Source = ApacheSpark.Tables("https://westus2.azuredatabricks.net:443/sql/protocolv1/o/5701963395210664/1217-051243-moos31", 2),
    sprinklrproduction_factsprinklrpostsummary = Source{[Schema="sprinklrproduction",Item="factsprinklrpostsummary"]}[Data]
in
    sprinklrproduction_factsprinklrpostsummary;

[andre]

you need to make some changes to you cluster configuration... details are here

https://businessintelligist.com/2019/04/11/how-to-make-azure-databricks-work-with-azure-data-lake-st...

[v-frfei-msft]

Hi @avinash_gatty ,

Based on my test, I cannot reproduce your issue here. I suggest to create a support ticket for help if you are a pro user.

https://powerbi.microsoft.com/en-us/support/

Regards,
Frank