Power BI Rest API - Upload Excel file

[Ganchut]

Hello. I am new to Power BI and I am trying to publish an Excel file through: https://docs.microsoft.com/en-us/rest/api/power-bi/imports/post-import.

I have created a powershell and I have no problems publishing PBI or RDL, but when I try to publish an Excel file it always returns a 400 error. Could you help me? Thank you very much and greetings.

[Ganchut]

Hi @v-shex-msft 

Effectively I am using the credentials of type "service principal". As I mentioned, I only have problems with Excel files.

These are XLSX, but they do not contain a table with data, but rather a report made with Excel with its connections to SSAS.

From the PowerBI portal, I can import the file without any problem, but when I try to import it through the API, it always returns a 400 error.

Thank you very much for your help.

[v-shex-msft]

Hi @Ganchut,

What version of the excel file are you tested?  According to the document, the current it only supports xlsx files.

In addition, What type of credentials are you using in these scripts? If you mean 'service principal', power bi has some limitations of this type of credentials usage.

Imports - Post Import - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Regards,

Xiaoxin Sheng

[Ganchut]

Hi @v-shex-msft 

Effectively I am using the credentials of type "service principal". As I mentioned, I only have problems with Excel files.

These are XLSX, but they do not contain a table with data, but rather a report made with Excel with its connections to SSAS.

From the PowerBI portal, I can import the file without any problem, but when I try to import it through the API, it always returns a 400 error.

Thank you very much for your help.

[v-shex-msft]

Hi @Ganchut,

Have you try to use the other methods to invoke the rest API? If these methods worked, they mean contain limitations to using 'service principal' credentials to invoke that API.

Regards,

Xiaoxin Sheng

[Ganchut]

Hello @v-shex-msft .

In the tests I have done I have not had problems publishing, updating, moving or deleting RDL or PBIX, I have only been unable to publish XLSX.