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

a3309361 99be-ea11-a812-000d3a8ddfb2 on 06 Jul 2020 00:10:09

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

https://docs.microsoft.com/en-us/power-query/connectors/datalakestorage

Analyze data in Azure Data Lake Storage Gen2 by using Power BIUse Power BI to analyze data stored in Azure Data Lake Storage Gen2docs.microsoft.com

Bhavik Ahir's profile image Profile Picture

ee056120 2405-41f5-b4c1-d9f44ab6c1ea on 06 Jul 2020 00:09:32

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

Any expected release date for this feature?

Bhavik Ahir's profile image Profile Picture

4a6e2edd 5661-4ab6-a668-f8dbc63be2bb on 06 Jul 2020 00:06: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

Any update on this please, without using Dataflows? we are looking to connect power bi as like source azure blob/azure SQL database.

Bhavik Ahir's profile image Profile Picture

da1a7643 f35d-4eb9-a1d8-4adc27cb532d on 06 Jul 2020 00:00:33

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

Any update on this please, without using Dataflows?

Bhavik Ahir's profile image Profile Picture

4ced723d d35a-4fab-9489-a3eeb797f137 on 05 Jul 2020 23:57: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

Now as this feature released (in Beta version). Does the step to use it different or same ?
https://docs.microsoft.com/en-gb/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2

Bhavik Ahir's profile image Profile Picture

edb707a8 095f-4e9a-b447-fe71e9b33fce on 05 Jul 2020 23:53:06

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

Is there a timeline for when the connector is exprected to be released? And until then a wokaround?I'm currently in trying to connect a Dynamics 365 Finance & Operations Entity Store in a Data Lake - and using the Azure Blob Storage connector all the metadata from model.json cannot be used.

Bhavik Ahir's profile image Profile Picture

b1134431 08f2-4aea-b1ba-be2ed15deddf on 05 Jul 2020 23:51:22

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

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://.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.

Bhavik Ahir's profile image Profile Picture

c814db87 b92e-46bc-8ee6-63ad496f42e7 on 05 Jul 2020 23:50:38

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

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

Bhavik Ahir's profile image Profile Picture

6b677af7 3a62-49e6-8413-4f13a34cf9a8 on 05 Jul 2020 23:48:12

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 MS pls expedite the release of this feature

Bhavik Ahir's profile image Profile Picture

2fd2a1be 9ac8-4dea-b262-01973dd9b26a on 05 Jul 2020 23:44:36

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

This feature will help us as well as many organizations,.