dataiku / dataiku-contrib

Public repository for DSS plugins
Apache License 2.0
101 stars 82 forks source link

PowerBI export data - structure visible but data empty #186

Open coindescanards opened 4 years ago

coindescanards commented 4 years ago

Hello

I have used the plugin to export a dataset into PowerBI The structure of the data has been correctly created but the rows of data didn't get exported 1) Is there a list of known reasons why dataset show as empty in PowerBI 2) As well is there a log of exports that we can analyse to check if errors are linked to format or other reason?

Thanks

hazmforce commented 4 years ago

Hello community ,

it seems an issue with dataset column datatype or non string value (bigint , int , boolean) all those datatype that are exported from dataiku dss flow are failing to be populated in the created dataset in powerbi although dataiku is able to create the dataset orginally if data column to be exported are switched to string that can be normally exported without errors my question would be if the dss plugin is correctly sending the correct datatype to the target datasets powerbi graphi api endpoint ( for bigint it should be int64 etc ) { "name": "DatasetName", "tables": [ { "name": "TableName", "columns": [ { "name": "ColumnName", "dataType": "int" },

with @coindescanards the exports of string data columns seems to work just fine

thanks for your input on this issue

Best regards

hazmforce commented 4 years ago

@alexbourret ?

alexbourret commented 4 years ago

Hi @hazmforce, The power-bi plugin has just been updated to version 1.1.3 to fix this issue. Let me know if you still experience any problem. Best Regards, Alex