Forum Discussion
Power BI Rest API - Upload Excel file
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
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.
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
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.