I have a report built-in Power BI, my question is how to upload data from excel in power BI every mo

[Anonymous]

Dear Admin

Thanks for this opportunity, i have a query and don't know how to solve it.

I build the Power BI report this month, I have data in excel from a different soft, my question is how can I add the data from excel in power bi. I want to cheep the same format in BI only to add data and to see the sales for next month.

Thank you very much.

Regards

Tanya

[santiagomur]

HI

if you only want a pic of the data from excel download the complement of power bi in excel with this you can create a dashboard using like "screenshots" of the excel data..

if you need to get the data try using one drive and creating a getaway to program the refresh 

[Anonymous]

Thank you very much for your replay. To be more expli..  This is the report in Desktop BI. How to add excel data every month in the same table which i have here in BI and to see how the Example Order line is diferent number because i will upload more order lines.

[santiagomur]

hi, 

you need to create an on-premise gateway is the only way i know to Scheduled a refresh. 

https://docs.microsoft.com/es-es/power-bi/service-gateway-onprem

[Anonymous]

sorry, where can i find the same info but in english😉

[santiagomur]

there is 

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

[Anonymous]

I think is not what I need or I am doing something wrong😥  I can't upload data from one month and to see the sales for that month in chart. Please if somebody can help me. Thank you very much.

[v-lili6-msft · Accepted solution]

hi @Anonymous 

I think you need set a Scheduled refresh for it.

https://docs.microsoft.com/en-us/power-bi/refresh-data

Do you mean that the different month data are indifferent excels?

If so, try to get data from folder and set Scheduled refresh for it.

https://powerbi.tips/2016/06/loading-data-from-folder/

Of course, you need to create an on-premise gateway.

Regards,

Lin