cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Data refresh by country wise

We are getting issue with data refresh as data volume is too high. And also it causing DB crash everytime. Can we import data by countrywise in power BI?
For EX:If I have countries like India,US,UK,Indonesia then first we will import data for india and subsequently for rest of countries but it should append the data in dataset for each country.

Please help me with your inputs.

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Data refresh by country wise

hi @NithinShetty 

For your case, It could not be achieved in power bi for now, I would suggest you these way:

1. use directquery instead of import.

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

2. you could use power bi Premium for the better refresh.

https://docs.microsoft.com/en-us/power-bi/service-premium-what-is

3. and also use Incremental refresh.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper II
Helper II

Re: Data refresh by country wise

Is there any way to append in append querries section for each country?

Highlighted
Community Support
Community Support

Re: Data refresh by country wise

hi @NithinShetty 

To my knowledge, It could not be achieved in power bi for now.

You may try the way as above.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors