Add news data in POWER BI Reports

[FabriceMorin]

Hello,

Is possible that a Power BI report can get new data automatically ?

For example If I have a report which displays amount of sales per month but when the report was created we got data only for January, Febuary, March, April and June (because we are in June) but data of July, August, September, ... Decembre will arrive at each end of month.

I want to know if it is possible that the report (already made in June) can automatically get the data of other months when they will be pushed in database (for example having the July data at the beginning of August) automatically.

Or do I have to update the new data by using the REST API ?

https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data-complete-code

Best Regards,

Fabrice

[v-yuta-msft]

Hi FabriceMorin,

"I want to know if it is possible that the report (already made in June) can automatically get the data of other months when they will be pushed in database (for example having the July data at the beginning of August) automatically."

<-- Where are your data from, SQL Server or other data source?

In addtion, are you going to use power bi service to achieve data automatically or build a three-party app to achieve data from azure using Rest API?

Regards,

Jimmy Tao

[FabriceMorin]

All my data are from SQL Server (always the same server and database).

For achieving I will use PBI Service.

Best Regards

[SivaMani]

@FabriceMorin,

The answer based on the following factors,

• What's the connectivity mode - is it Import?
• What's your source - On-prem or Cloud

[FabriceMorin]

Hello,

my source is a database SQL Server and for the connectivity it could be anything.

But in order to do what I want, I suppose that the only possible options are :

•  Import initial + new data with REST API
• DirectQuery