dataiku-contrib icon indicating copy to clipboard operation
dataiku-contrib copied to clipboard

PowerBI export data - structure visible but data empty

Open coindescanards opened this issue 6 years ago • 3 comments

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

coindescanards avatar Mar 12 '20 17:03 coindescanards

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 avatar Mar 24 '20 18:03 hazmforce

@alexbourret ?

hazmforce avatar Apr 02 '20 18:04 hazmforce

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

alexbourret avatar Apr 02 '20 18:04 alexbourret