Is there any Apache Iceberg connector in power bi

[pappgabor]

Hi,
There is a post from 2023 about powerbi not having a connector for reading Iceberg file format: https://community.fabric.microsoft.com/t5/Fabric-platform/Read-parquet-file-from-Apache-Iceberg-from...

. I would like to know if this is still the case? My problem is, how to read data from iceberg format into powerbi report. I know there are workarounds and shortcuts (e.g. via synapse), but it would be best if there was such a connector. Thanks a lot!

[AntoineW · Accepted solution]

Hello @pappgabor,

Thanks for the question, I understand you frustration, for now, there’s still no native Iceberg connector in Power BI.

However, Microsoft Fabric’s OneLake now virtualizes Delta Lake tables as Iceberg (and vice versa) via metadata. Enable the Delta-to-Iceberg virtualization in your workspace settings to make tables interoperable without rewriting. And if you're moving data, Data Factory's Copy activity can output in Iceberg format directly to ADLS Gen2.

Source : 

- https://learn.microsoft.com/en-us/fabric/onelake/onelake-iceberg-tables

- https://blog.fabric.microsoft.com/en-GB/blog/new-in-onelake-access-your-delta-lake-tables-as-iceberg...

- https://learn.microsoft.com/fr-fr/fabric/data-factory/format-iceberg

Hope it can help you !

Best regards,

Antoine

[v-karpurapud · Accepted solution]

Hi @pappgabor 

Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to @AntoineW    for offering helpful suggestions.

Could you let us know if the suggested solution resolved your issue?If you still need help, please share more details so we can assist you further.

Thank you.

[AntoineW · Accepted solution]

Hello @pappgabor,

Thanks for the question, I understand you frustration, for now, there’s still no native Iceberg connector in Power BI.

However, Microsoft Fabric’s OneLake now virtualizes Delta Lake tables as Iceberg (and vice versa) via metadata. Enable the Delta-to-Iceberg virtualization in your workspace settings to make tables interoperable without rewriting. And if you're moving data, Data Factory's Copy activity can output in Iceberg format directly to ADLS Gen2.

Source : 

- https://learn.microsoft.com/en-us/fabric/onelake/onelake-iceberg-tables

- https://blog.fabric.microsoft.com/en-GB/blog/new-in-onelake-access-your-delta-lake-tables-as-iceberg...

- https://learn.microsoft.com/fr-fr/fabric/data-factory/format-iceberg

Hope it can help you !

Best regards,

Antoine

[pappgabor]

Thank you, Antoine!