topic Re: Create a Report using JSON, CSV or Excel File with Power Bi Rest API in Developer

Create a Report using JSON, CSV or Excel File with Power Bi Rest API

keshavram-kudwa — Wed, 28 Dec 2022 17:41:27 GMT

I can have my data in three different file formats i.e. JSON, CSV or Excel. I want to create a report using Power Bi Rest API. I tried to use the https://learn.microsoft.com/en-us/rest/api/power-bi/imports/post-import API but I'm getting the following errors:

{ "error": { "code": "RequestedFileIsEncryptedOrCorrupted", "pbi.error": { "code": "RequestedFileIsEncryptedOrCorrupted", "parameters": {}, "details": [], "exceptionCulprit": 1 } } }

I have used OAuth Authentication here. What is the proper way to create a report with raw data using Power Bi Rest API? If there is one, is there a step-by-step guide anywhere.

Re: Create a Report using JSON, CSV or Excel File with Power Bi Rest API

v-jianboli-msft — Thu, 29 Dec 2022 02:28:42 GMT

Hi @keshavram-kudwa ,

This API is used to create new content in My Workspace.

Please check the limitations of this API:

Dataflows with service principal aren't supported.
Importing a Power BI .pbix file from OneDrive isn't supported.
Importing a file that has a protected sensitivity label isn't supported for service principals.

Moreover you need to ensure that the datasetDisplayName property/argument ends with .json/.csv/.xlsx

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Re: Create a Report using JSON, CSV or Excel File with Power Bi Rest API

keshavram-kudwa — Thu, 29 Dec 2022 09:12:31 GMT

Hi @v-jianboli-msft,

Thanks for responding, I tried your solution but now I get the following error:

{ "error": { "code": "InvalidRequest", "message": "Invalid dataflow structure. Exception details: <pi>Cannot populate JSON array onto type 'Microsoft.Cdsa.ObjectModel.Model'. Path '', line 1, position 1.</pi>" } }

Here's a glimpse of my data:

[{"vin":"1VWAH7A38CC981838","make":"GMC","model":"Yukon XL 2500","year":2008}, {"vin":"WAUAF78E28A028588","make":"Pontiac","model":"Bonneville","year":1997}, {"vin":"WA1WYAFE9AD228868","make":"Hummer","model":"H3","year":2008}, {"vin":"WA1CFAFP1EA504218","make":"Oldsmobile","model":"Aurora","year":2003}, {"vin":"WAUFFAFL1CN972498","make":"Nissan","model":"Murano","year":2005}]