Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Power BI Desktop July 2018 Update Unable to Connect to Azure Data Lake Store

Ever since updating Power BI Desktop to July 2018, it can no longer connect to Azure Data Lake Store.  Others on my team who did not update and are on May 2018 or April 2018 are able to connect just fine.

 

Steps to re-create:

Open Power BI Desktop, verify you're logged in.

Click Get Data

Select Azure/Azure Data Lake Store

Click Connect

Enter the Azure Data Lake Store HTTPS:// or ADL:// link in the URL box.  Leave optional "Page size in bytes (optional)" blank.

Click OK

Error message immediately pops up.  Never prompted for Azure login and Power Query Editor never opens.

Message recieved is:

Unable to connect

We encountered an error while trying to connect

Details: "We cannot convert the value null to type Logical"

Unable to Connect.jpg

Status: Accepted
Comments
brika
Frequent Visitor

Same here.

v-yuezhe-msft
Employee

@Anonymous @brika,

I have reported this issue internally : CRI 78852094. Will post back once I get any updates.

Meanwhile, you can use the following workaround. In Power BI Desktop, open a new blank query and enter the following code in Advanced Editor.


let

    Source = DataLake.Contents("URL")

in

    Source



Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Accepted
 
v-yuezhe-msft
Employee

@Anonymous @brika,

This issue will be fixed in Power BI Desktop September release.

Regards,
Lydia

v-yuezhe-msft
Employee

@Anonymous @brika,

Please check if you still get same error in Power BI Desktop September release.

Regards,
Lydia