Anonymous's avatar
Anonymous
Not applicable
8 years ago
Status:
Accepted

Azure Data Lake refresh issue

I have my Power BI report using as source Azure Data Lake Store with no issues. After publish the report, I can't setup refresh due error message  You can't schedule refresh for this dataset becaus...
Reports
leestott's avatar
leestott
Regular Visitor
7 years ago

Hi if your getting this error when trying to connect to a data source

ErrorPowerBi.GIF

Unable to connect 

We encountered an error while trying to connect 

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

 

To fix this follow the following steps 

 

Step 1. Press Cancel on the Error

Step 2. Select Get Data from the ribbon 

Step 3. Select More 

Step 4. Choose Other -> Blank Query 

Step 5. Click Connect 

Step 6. A new PowerQuery Editor will open 

Step 7. Select the view from the menu 

Step 8. Select advanced editor 

Step 9. In the advanced editor query add  ,null to  the end of your connection string previously used 

 

##Example - connecting to an azure data lake## 

 

let
    Source = DataLake.Contents("adl://data.azuredatalakestore.net/local_data/", null)
in
    Source

 

Step 10 Click Done

Step 11 The data will now load and refresh

Completed Ideas