Skip to main content

    Power BI

    New

    Azure Data Lake Analytics data source

    Vote (70) Share
    Thomas Jespersen's profile image

    Thomas Jespersen on 18 Jun 2017 17:54:00

    Now we have Azure Data Lake Store as data source in Power BI Desktop which is great.

    But we also need acces to Azure Data Lake Analytics catalogs.

    Comments (4)
    Thomas Jespersen's profile image Profile Picture

    794e3539 8146-4890-8765-5a08f327adf1 on 05 Jul 2020 23:31:09

    RE: Azure Data Lake Analytics data source

    Yeah, what's the point of having all these data features that aren't supported? :/
    Why is this all so complicated? Ugh.

    Thomas Jespersen's profile image Profile Picture

    870d4322 599c-47b7-a6be-1381dcdf86fe on 05 Jul 2020 23:25:21

    RE: Azure Data Lake Analytics data source

    Please allow to access data stored in USQL tables from Power BI

    Thomas Jespersen's profile image Profile Picture

    8c08c700 c22c-46c5-becd-a4d32d6a5cc1 on 05 Jul 2020 23:25:05

    RE: Azure Data Lake Analytics data source

    Catalogs should be the preferred way to connect to your data lake. I don't see any good reason why the schema needs to be reimplemented on the Power BI side, when it's already there in the data lake.

    Thomas Jespersen's profile image Profile Picture

    5a173d26 b3bc-409f-b8ea-04d9d488f3bf on 05 Jul 2020 23:24:15

    RE: Azure Data Lake Analytics data source

    This is a must-have feature, and it should definitively support Directquery, since ADLA Tables can be of Terabyte size.

    It seems that currently the only way to read ADLA Tables is to put Azure Analysis Services in between, but even AAS does not support Directquery!