Exporting dataset to Power BI
When I am exporting a dataset to Power BI. I can see the dataset is getting created in Power BI with table name dss_data and schema of the table.
But, I am unable to see any records in the dataset. Can you please suggest what might be going wrong?
Best Answer
-
piyushk Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Adv Designer, Registered Posts: 55 ✭✭✭✭✭Options
I got the solution. There was the issue of parsing the dataset datatype value on Power BI end. Apparently, the plugin uses Pandas dtype to specify the datatype of the column.
Therefore, convert the column/schema datatype to string on DSS end and then export the dataset to Power BI.
Answers
-
Hi, may I ask you how you export your dataset into Power bi ?
-
piyushk Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Adv Designer, Registered Posts: 55 ✭✭✭✭✭Options
Pre requisite-Register application in azure and note down client secret and client id
Make sure user account has login access to Power BI
Select a dataset to be exported, choose any one options from the drop-down. Provide required details and hit export. Your dataset got exported to Power BI.
