Forum Discussion
Helper IVupdate a report post automatically in SHAREPOINT
Hello everyone!
I have posted a report so my entire team can see it. The problem I find myself in is that I must add the data on a daily basis manually. Adding the data in row shapes in an EXCEL. The problem that is going to happen with this, is that excel does not support more than a million rows and therefore could not have that consolidated. Therefore, what I want to learn is how to add an excel to SHAREPOINT (with the same format as the report, i.e. the same number of columns and headers), so that you only have to add a new excel to the sharepoint with the daily information and power bi automatically do the data union.
PS: I have POWER BI PRO. so it's no problem if it should be pro the account.
7 Replies
- mhossain
Solution Sage
Hi CLCastroEn
So your excel file will have more than a million records? is that the problem. There are multiple solution.
However can you try to import the folder, lets say you have multiple excel files in a folder, powerbi will automatically union it. Will this solve your problem.
Or explain more what exactly you want to achieve?
CLCastroEn@mhossain then power bi joins all the data automatically? Or should I do something?
Will the report be updated automatically?
- amitchandak
Super User
CLCastroEn , there are multiple files with same structure you can use folder import
- amitchandak
CLCastroEn , not very clear to me.
refer if this can be bit of help
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
