Refresh the tables in different timing

[vinothkumar1990]

Hi,

 I have two different datasources in a Power BI temlate. First one is SQL Server and second one is SAP BW. I have created the many calculated columns using Ralated function to compare both the data(e.g. IF(RELATED(SAPBW[COL1]) = SQL[COL1], "Match", "Mis Match")). Due to some reason, i want to refresh only the SAP BW data at 4AM and SQL Server data at 7 PM. Is there any way to refresh these data in different times.

Note:

I have created the SAP BW dataset template and uploaded them in Power BI Service and then called them as live connection in another SQL Server dataset template but the calculated columns are not working.

[vinothkumar1990]

I have created two live connections but the "Related" function is not working to compare both the source and target columns. Is there is any way

[vinothkumar1990]

Hi,

  I have tried this soluction, i am able to refresh the source data in different times but i am not able to create the calculated columns(e.g. IF(RELATED(SAPBW[COL1]) = SQL[COL1], "Match", "Mis Match"))

Thanks,

Vinoth

[v-luwang-msft]

Hi @vinothkumar1990 ,

Data refresh is based on dataset .Even the  data of report from different data source ,after you published, in Power BI

Service ,only have one dataset.And when you refresh the dataset, the data sources involved in the dataset are refreshed together.The only way is exactly collinq so mentioned ,split the two datasources into two separate reports and then combine those later into one (or into a report) you could have them update at different times. 

 The following article may be helpful for you:

Refreshing from multiple data sources, on different time of day

Best Regards

Lucien

[collinq · Accepted solution]

HI @vinothkumar1990 ,

I do not beliee that there is a way to separate refreshes on datasources on one single report.  However, if you split the two datasources into two separate reports and then combine those later into one (or into a report) you could have them update at different times.  Or, you could use a dataflow and have that update at one point and then combine that to a report.  The issue is that datsources within a file become one dataset and the dataset is what is refreshed - thereby, all datasources within the report get refreshed at once.