How can we improve Power BI?

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

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) .

60 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Bhavik Ahir shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

7 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Kanad Chatterjee commented  ·   ·  Flag as inappropriate

    My 2 cents here, to connect ADLS Gen2 to Power BI. Hope this helps someone struggling with this, the way I was for the last month :)

    1. ADLS Gen2 (with Hierarchical Namespace on) - You can slap a JSON schema on top of your file (has to be named Model.json) and then consume it in Power BI through Dataflows (would need to have Power BI Premium subscription as dataflows can only be defined in Premium workspaces). Here's a nice blog explaining this - https://blog.crossjoin.co.uk/2019/03/13/attaching-manually-created-common-data-model-folders-in-power-bi-dataflows/

    2. ADLS Gen2 (with Hierarchical Namespace off) - You can connect to this using the Azure Blob Storage connector for Power BI (will have to use the blob service endpoint, https://<storage-account>.blob.core.windows.net/). You can then import the file as a Binary (Power BI is able to auto-detect CSV, so will save you some headache there). And then do a proper schema definition etc. within Power BI. Only downside is, unlike through dataflows this wouldn't be shareable across reports.

  • Anonymous commented  ·   ·  Flag as inappropriate

    This is related to the issue with the blob api's for the life of me not sure why it is not fixed yet.

  • Lauri commented  ·   ·  Flag as inappropriate

    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.

  • Stan Livingston commented  ·   ·  Flag as inappropriate

    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.'.

  • Geoff Williams commented  ·   ·  Flag as inappropriate

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

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.