topic Re: Power BI Rest API - Upload Excel file in Developer

Power BI Rest API - Upload Excel file

Ganchut — Thu, 08 Sep 2022 06:24:42 GMT

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.

Re: Power BI Rest API - Upload Excel file

Anonymous — Fri, 09 Sep 2022 00:49:32 GMT

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

Re: Power BI Rest API - Upload Excel file

Ganchut — Fri, 09 Sep 2022 09:46:44 GMT

Hi @Anonymous

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.

Re: Power BI Rest API - Upload Excel file

Ganchut — Tue, 13 Sep 2022 07:15:07 GMT

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.

Re: Power BI Rest API - Upload Excel file

Anonymous — Tue, 27 Sep 2022 08:37:08 GMT

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

Re: Power BI Rest API - Upload Excel file

Ganchut — Tue, 27 Sep 2022 15:40:25 GMT

Hello @Anonymous .

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.