Azure Data Lake refresh issue

[Anonymous]

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 because one or more sources currently don't support refresh.

Discover Data SourcesThis has been working before

, 

[sundarram]

Its working fine now. I republished the report from desktop. 

[v-qiuyu-msft]

Hi all, 

This issue should be resolved in all prod clusters. Please test again in your environment. 

Best Regards,
Qiuyun Yu 

[lightwaver]

Hi,

Well yes there is a difference - it no longer says that the refresh is not available, but i still get an error:

Unable to refresh the model (id=4154068) because it references an unsupported data source.

and after a while i got the following error:

 Message:
We cannot convert the value null to type Logical. Table: DataLake.
Cluster-URI:
WABI-NORTH-EUROPE-redirect.analysis.windows.net
Aktivitäts-ID:
25816838-c5dc-5607-3295-c73439b1de30
Anforderungs-ID:
a8cebb7f-2a1c-913c-4677-27fc0b0dd00b
Zeit:
2018-07-06 10:01:35Z

regards

   Stefan M. Marek

[joanavb]

Not solved...

We've tried with a Power BI with the simplest connection to Data Lake but keep getting that error too:

Error

Message: We cannot convert the value null to type Logical. Table: Query1 (2).
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: b4b220ac-1f92-458d-90e5-cc5b646c1079
Request ID: 8593fb22-c488-78c1-e0a3-c6894e91721e
Time: 2018-07-06 10:20:47Z

Power Query:

let

    Source = DataLake.Contents("adl://[datalakeaccount].azuredatalakestore.net/DevInfo/Output", [])

in

    Source

[v-keg]

I had the same issue. Fixed it by removing the [] from the DataLake.Contents command. Change your command as follows:

Source = DataLake.Contents("adl://[datalakeaccount].azuredatalakestore.net/DevInfo/Output")

[Anonymous]

Hi All

Unfortunatelly it is not working for me.

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

I have reviewed and my source doesn't have "[...]"

As you can imagine I can refresh from Power BI desktop all my reports, but not from Service.

@PowerBI team, after one month we are still waiting for profesional solution, customers pay licenses and Power BI is not in BETA.

Regards

Roy

[sundarram]

I am facing the same null exception. However its working fine in desktop mode.

Data source error:	We cannot convert the value null to type Logical.. The exception was raised by the IDbCommand interface. Table: .
Cluster URI:	WABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity ID:	a0e26ee7-4bbf-435d-a072-5e6840c0238c
Request ID:	aeadeb0d-9ac3-4458-a692-37f72e257091
Time:	2018-07-07 10:03:17Z

[v-qiuyu-msft]

Hi all,

I have consulted this issue internally, will update here once I get information. 

Best Regards,
Qiuyun Yu 

[jefflaw]

I have the same issue with trying to use Data Lake storage. Like others, my data refresh works fine when refreshing in PowerBI Desktop, but not when published and using the service.

Message:	We cannot convert the value null to type Logical. Table: DataQuery.
Cluster URI:	WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID:	331e2bea-d3c2-c9f0-a9cb-efae4439ca70
Request ID:	87784e4e-7b9b-e596-5944-f27ff747073c
Time:	2018-07-18 03:14:19Z

Ive tried removing the [] in the connection to Data Lake as suggested, but still have the same problem.

Its been a week since the last post. Any updates, or better yet, fixes. 

Regards

Jeff

[v-qiuyu-msft]

Hi all,

Regarding the error "We cannot convert the value null to type Logical", the fix will reach PROD on August. 

Simple workaround - simply do not pass an empty record as the second parameter.

EX: DataLake.Contents(url); instead of DataLake.Contents(url, []);

Best Regards,
Qiuyun Yu