Request for help : delta lake to power bi

[nadine ben harrath]

Hello community , i'm trying to save stream data in delta lake and i want to push this data to power bi for real time insights , however when i try to connect databricks to power bi i get an empty table , someone can help me please ?? 

if there's another alternative it would be grateful 

thank you 

[nadine ben harrath]

please someone to help me , it's urgent ? 

thank you 

[Denny Lee]

Hi Nadine,

By any chance would the Power BI / Delta Lake connector work for you?   It's currently being included as part of the connectors as part of PR#87 thanks to Gerhard Brueckl as well.

HTH!

Denny Lee
denn...@databricks.com

Sent via Superhuman

--
You received this message because you are subscribed to the Google Groups "Delta Lake Users and Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to delta-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/delta-users/de3b83da-4954-435c-a449-5bb67b29cc84n%40googlegroups.com.

[nadine ben harrath]

this is the error i'm getting :

DataSource.Error : ODBC: ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'Error operating GET_COLUMNS Unrecognized type name: STRUCT<`type`: TINYINT, `size`: INT, `indices`: ARRAY<INT>, `values`: ARRAY<DOUBLE>>'.

Détails :

    DataSourceKind=Databricks

    DataSourcePath={"host":"adb-775013124209131.11.azuredatabricks.net","httpPath":"sql\/protocolv1\/o\/775013124209131\/0516-223443-joked310"}

    OdbcErrors=[Table]

i'm trying to write stream data in delta table and then pushing it to power bi using directquery for real time visualizations 

i'm sorry for disturbing Mr Denny but i'm still beginner using databricks and delta lake , it's the first time i'm using this 

Le lundi 17 mai 2021 à 21:36:06 UTC+1, denn...@databricks.com a écrit :

Hi Nadine,

By any chance would the Power BI / Delta Lake connector work for you?   It's currently being included as part of the connectors as part of PR#87 thanks to Gerhard Brueckl as well.

HTH!

Denny Lee
denn...@databricks.com

Sent via Superhuman

On Mon, May 17, 2021 at 12:24 PM, nadine ben harrath <nadinebe...@gmail.com> wrote:

please someone to help me , it's urgent ? 

thank you 

Le lundi 17 mai 2021 à 16:50:36 UTC+1, nadine ben harrath a écrit :

Hello community , i'm trying to save stream data in delta lake and i want to push this data to power bi for real time insights , however when i try to connect databricks to power bi i get an empty table , someone can help me please ?? 

if there's another alternative it would be grateful 

thank you 

--
You received this message because you are subscribed to the Google Groups "Delta Lake Users and Developers" group.

To unsubscribe from this group and stop receiving emails from it, send an email to delta-users...@googlegroups.com.

[ashitabh kumar]

Hi Nadine, 

Struct datatype is not recognized by odbc it seems, so you need to create a view over exploded columns of the struct column. Then you can use this view from PowerBI. Ensure that all struct columns are casted to proper datatypes 

https://docs.microsoft.com/en-us/azure/databricks/spark/latest/spark-sql/language-manual/sql-ref-syntax-ddl-create-view

To view this discussion on the web visit https://groups.google.com/d/msgid/delta-users/a65ad138-48d7-4dc3-9012-cff8a4084474n%40googlegroups.com.