Forum Discussion

Ganchut's avatar
Ganchut
New Member
3 years ago

Power BI Rest API - Upload Excel file

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 pr...
Need Help
Ganchut's avatar
Ganchut
New Member
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    Ganchut
    New Member
    3 years ago

    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.