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
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.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors