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
jefflaw's avatar
jefflaw
Frequent Visitor
7 years ago

Unfortunately, I am still experiancing this issue. I have it working when I do a refresh through PowerBI Desktop. It will not work if I do a refresh through the PowerBI Service.

 

I have just downloaded the latest version of PowerBI Desktop (October 2018) and no improvement.

 

I have tried 3 different options for the Source string:

1) 

Source = DataLake.Contents("ourstorage.azuredatalakestore.net/appinsights/processed/v2/Event/DataQuery/", [PageSize=null])

2) 

Source = DataLake.Contents("ourstorage.azuredatalakestore.net/appinsights/processed/v2/Event/DataQuery/", null),

 

3) 

Source = DataLake.Contents("ourstorage.azuredatalakestore.net/appinsights/processed/v2/Event/DataQuery/"),

 

The error message is always the same. (Apart from the ID's and time)

Something went wrong

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

Message: We cannot convert the value null to type Logical. Table: Query1.

Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Activity ID: f5b4aa9b-4caa-435a-bbcc-19a27bbb8c86

Request ID: 20c49253-7a34-08aa-1c55-a5a99f5530d5

Time: 2018-10-18 21:32:21Z

 

 

It is interesting that some people have apparently managed to work around this issue. I just wish that I was one of them.

 

Having gotten used to the Azure world where I can log an issue direct with support and I get a response from MS, and we work through the issue, how do I do the same with PowerBI? I keep arriving back here. Is this it?

 

Regards

Jeff

Completed Ideas