Skip to main content

    Power BI

    Planned

    Power BI direct connector to ADLS2 (Azure Data Lake Storage Gen2) thus Power BI directly connect to ADLS2 for reporting and Firewall slider

    Vote (200) Share
    Bhavik Ahir's profile image

    Bhavik Ahir on 05 Mar 2019 07:10:39

    currently Power BI does not have direct connection to ADLS2 and requires Power BI Dataflow to access the ADLS2 data which causing data redundancy and creating extra hop for the same data and can be directly consume form ADLS2. Power BI direct connection with ADLS2 is great addition for Advance Data Analytics and firewall slider Power BI which enable exclusive access Power BI similar to AAS (Azure Analysis Service) .

    Administrator on 13 Apr 2019 02:42:11

    We plan to add an ADLS Gen2 connector to Power BI later this year. Stay tuned!

    Comments (13)
    Bhavik Ahir's profile image Profile Picture

    5a173d26 b3bc-409f-b8ea-04d9d488f3bf on 05 Jul 2020 23:44:16

    RE: Power BI direct connector to ADLS2 (Azure Data Lake Storage Gen2) thus Power BI directly connect to ADLS2 for reporting and Firewall slider

    I presume this will not be fixed until the Blob APIs have been enabled for Data Lake Gen2. So the bottleneck is on the ADLS side, not Power BI.

    Bhavik Ahir's profile image Profile Picture

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

    RE: Power BI direct connector to ADLS2 (Azure Data Lake Storage Gen2) thus Power BI directly connect to ADLS2 for reporting and Firewall slider

    Can't seem to connect with Power BI or Power BI Data Flow. Keep getting a Blob API error. Status code: 400, description: 'Blob API is not yet supported for hierarchical namespace accounts.'.

    Bhavik Ahir's profile image Profile Picture

    f2f3c56e 057e-460d-8e45-5658bf4fb2c3 on 05 Jul 2020 23:39:34

    RE: Power BI direct connector to ADLS2 (Azure Data Lake Storage Gen2) thus Power BI directly connect to ADLS2 for reporting and Firewall slider

    Currently cannot use Data Lake Gen2 in Get Data only for dataflows. We should be able to do a Get Data on dfs locations