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
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors