Forum Discussion
Teams powerbi app excel header
Hi all
I am facing issues to null value headers.
I use teams app and in the app, i use power bi.
To use power bi, i used my excel file from one drive.
when I import the file to power bi, i didn't have any access to change headers unlike the power BI desktop.
The reason why i need to use power bi app is to share with collegues.
Could you please help me to fix the issue?
I want the 3rd row as a header in the excel file when i import the file to power bi.
Thank you in advance
Hi. Only Power Bi Desktop can transform data before loading. You can use Desktop to get data from onedrive and then publish that to PowerBi Service Portal in order to share with other users, you don't neet to use the Service directly. You can get the data from files like this:
https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive
Then publish: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files
I hope that helps,
1 Reply
- ibarrau
Super User
Hi. Only Power Bi Desktop can transform data before loading. You can use Desktop to get data from onedrive and then publish that to PowerBi Service Portal in order to share with other users, you don't neet to use the Service directly. You can get the data from files like this:
https://blog.ladataweb.com.ar/post/185337134590/alternativa-para-conectar-power-bi-a-onedrive
Then publish: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-upload-desktop-files
I hope that helps,