Skip to main content

Power BI

New

DirectQuery for Azure Data Lake Store connections

Vote (35) Share
Abhay Bisht's profile image

Abhay Bisht on 18 Dec 2017 19:00:24

When a Power BI report is connected to ADLS data source then it behaves like an Import mode application in which first all the data is imported. The report in service needs to be set with refresh time also.



The ADLS connection is not working as DirectQuery mode and neither there is an option to automatically scan for a refresh of dataset periodically. Please support Direct Query for ADLS Data Source.

Comments (3)
Abhay Bisht's profile image Profile Picture

d27011aa bebb-49b9-b196-a2c1af7a22b2 on 06 Jul 2020 00:00:07

RE: DirectQuery for Azure Data Lake Store connections

Necessary to utilize D365FO's automated entity store refresh to Azure Data Lake. It really makes no sense to be limited to import mode when you have live data available.

Abhay Bisht's profile image Profile Picture

d0aca558 5e84-498a-9cd8-6d63f1fe0aea on 05 Jul 2020 23:26:19

RE: DirectQuery for Azure Data Lake Store connections

Agree, I hope that Data Source of Azure Data Lake Store support DirectQuery.
for analyze hundreds terabytes data with PC.

Or I hope that Data Source of Azure Data Lake support DirectQuery

Abhay Bisht's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 23:18:23

RE: DirectQuery for Azure Data Lake Store connections

This would be awesome! if we can use poly base or U-SQL to direct query the ADL.