Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear community,
I wanted to see if somebody has implemented integration Azure Data Lake Analytics as a source with visualization in Power BI Service.
A size of tables can be 2-50 GB.
Here are some research results done by me:
,
What other options which you know? More stable or easier ones?
Regards,
Ruslan
HI @zoloturu,
>>You can add a script to ADLA to store your data in Azure Data Lake Store (ADLS). And then you will be able to refresh it from Power BI Desktop, in the meantime, it is not possible from Power BI Service.
Azure data lake service not need to use gateway to handling refresh operation, you can update its credentials to use on power bi service.
If you mean you are deal with a mixed datasource report which contains azure data lake service, please use personal gateway to handling with this scenario and confirm there are no combine/merge or custom function operate in it.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft,
Let me explain it more. In this option which you've commented, I try to connect to ADLS from Power BI Desktop, but when I publish this report to Power BI Service I further not able to refresh it in a cloud.
Regards,
Ruslan
HI @zoloturu,
If your report only contains online service without any advanced operations(append/merge, custom funciton, reference other query), you can direct use connection directly mode to link datasource without a gateway.
If your datasource contains multiple data sources with both online and on premise datasource at same time, you can use personal gateway to handling these scenario.
In addition, you can also turn on below option to use on premise gateway to handling online service(not need to config correspond datasource).
Notice: on premise gateway not support to handling multiple datasource type(online and on premise) with advanced operations.
Combine enterprise gateway and online data sources
The initial support will enable refreshing datasets that connect to Online and On-prem sources but that do not “mash up” data between them. (i.e. no Merge/Append or other query references involved).
If above still not help, please open a support ticket for better support.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.