Forum Discussion

avinash_gatty's avatar
avinash_gatty
New Member
7 years ago

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

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;

2 Replies