Hi Team,
Need clarity on below mentions queries
We are using POST https://api.powerbi.com/v1.0/myorg/datasets api to create dataset. As the defaultMode flag was not set, the dataset created was push dataset only. Additionally, we are exporting the data into Power BI using POST https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/tables/{tableName}/rows api which is used for push dataset.
We are seeing that one of our customer is facing an issue in exporting data into power BI where we internally call the above POST api to push data and export is failing with the below exception. The tenant name is 'fsresidential.onmicrosoft.com', dataset id is 'd080a4fd-098b-425f-98a6-9cab8092b37b' and the table name is 'LearnerTranscript'.
API response:
{"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|d080a4fd-098b-425f-98a6-9cab8092b37b: Conversion error on column '<pi>Training or Module Duration (mins)</pi>': <pi>Input string was not in a correct format.</pi>"}}
Splunk logs:
cluster=connector_worker uuid=connectorWorker8b577d5b4d574046b857ae9a18de2c02, 2022-09-21 13:52:23,169 [syncWorkerTaskExecutor-1] E| c.a.p.worker.SyncWorkerListener - Error in processing the SyncTask : Error in posting the data into the Power BI. Error : Error while pushing data into Power BI dataset. Message : {"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|d080a4fd-098b-425f-98a6-9cab8092b37b: Conversion error on column '<pi>Training or Module Duration (mins)</pi>': <pi>Input string was not in a correct format.</pi>"}}
com.adobe.primelms.esi.common.CustomException: Error in posting the data into the Power BI. Error : Error while pushing data into Power BI dataset. Message : {"error":{"code":"InvalidRequest","message":"Error parsing request for dataset sobe_wowvirtualserver|d080a4fd-098b-425f-98a6-9cab8092b37b: Conversion error on column '<pi>Training or Module Duration (mins)</pi>': <pi>Input string was not in a correct format.</pi>"}}
We are suspecting that the customer's dataset type is push+streaming dataset and that's why it's failing intermittently especially when the data in the post call is more than a few MBs. Is there any way to convert the dataset to streaming through UI?
What could be the possible reason for the export failure as the above logs suggest?
