cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LucienF38 Regular Visitor
Regular Visitor

ADD NEW MONTHLY ROWS FROM EXCEL FILE

Dear all,

 

I have a table imported from excel into PBI.

Every month I add new rows in my excel file under the existing rows (If it is easier, in can enter this data in a new sheet instead of putting it under the existing data).

Is it possible to add these new rows only under the ones already in PBI, and then it would refresh the visualization taking into account this new data? If yes, how ?

 

Next step is to make a automatic refresh each month, is this possible ?

 

Thanks for helping Smiley Happy 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
vanessafvg Super Contributor
Super Contributor

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

@LucienF38  what is the purpose of having the new lines separate, if you just add it intot the file you have already it will automatically bring through all those rows when you refresh. 

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Super User
Super User

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

Hello @LucienF38 

When you say it is imported from Excel you mean, in PowerBI Desktop you went through Get Data > Excel > your file.  So under Data source settings (Home > Edit Queries > Data Source Settings) you see the excel file.

DataSource.jpg

If so, when you add new data to the excel file, when you hit refresh in PowerBI Desktop it will pull in the new data.  If you publish the report to the service, you will need a gateway that has access to the location of the excel file but then you can configure the dataset to refresh automatically and the report will pull everything from the excel file.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

 

6 REPLIES 6
Vvelarde Super Contributor
Super Contributor

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

@LucienF38 

 

Hi, in Query Editor, you can load the sheets and apply an Append.

 

Regards

Victor

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




LucienF38 Regular Visitor
Regular Visitor

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

Hi @Vvelarde ,

 

Thanks for your answer. 

So you recommend not to add my lines under my main file but in a different sheet ? 

Also, do you have any idea on making it automatic ? Maybe I would need to upload my files in a sharepoint and then code something into PBI?

 

Thanks 

Highlighted
vanessafvg Super Contributor
Super Contributor

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

@LucienF38  what is the purpose of having the new lines separate, if you just add it intot the file you have already it will automatically bring through all those rows when you refresh. 

 

 


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
Super User
Super User

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

Hello @LucienF38 

When you say it is imported from Excel you mean, in PowerBI Desktop you went through Get Data > Excel > your file.  So under Data source settings (Home > Edit Queries > Data Source Settings) you see the excel file.

DataSource.jpg

If so, when you add new data to the excel file, when you hit refresh in PowerBI Desktop it will pull in the new data.  If you publish the report to the service, you will need a gateway that has access to the location of the excel file but then you can configure the dataset to refresh automatically and the report will pull everything from the excel file.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

 

LucienF38 Regular Visitor
Regular Visitor

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

@vanessafvg , Thank you, I didn't know refresh was working from an Excel file ! 

LucienF38 Regular Visitor
Regular Visitor

Re: ADD NEW MONTHLY ROWS FROM EXCEL FILE

@jdbuchanan71 , Thank you for the second question Smiley Happy 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 352 members 3,677 guests
Please welcome our newest community members: