Automatic sampling from existing t

[Viki_5]

So I have a table in my dashboard and the data in that table is updated everyday automatically,
Now I want to create a new table by sampling this big table, based on different categories. I'm currently doing it on Python in VSC, and the sampled rows are updated in the excel sheet. I just want to move this functionality to powerBI. Is it possible? If so, How?

[Anonymous]

Hello,@anmolmalviya05 and @SaiTejaTalasila .Thanks for your concern about this issue.

Your answers are excellent!
Hi,@Viki_5 I am glad to help you.

Has your problem been solved?

If you have found suitable solutions, please share them as it will help more users with similar problems.
Or you can mark the valid suggestions provided by other users as solutions.

In fact that the suggestions provided by other users are great, you could  process the data in Power Query and then implement a schedule refresh through the Power BI gateway.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian

[SaiTejaTalasila · Accepted solution]

Hi @Viki_5 ,

You can do that with power query but you need to use a personal gateway of you want to refresh the reports on power bi service.

If you a  fabric premium capacity workspace then you can use fabric notebooks too.

Thanks,

Sai Teja 

Thanks,

Sai Teja 

[anmolmalviya05]

Hi @Viki_5, Hope you are doing good!
Yes you can definitely move your data sampling process from Python to Power BI!
Firstly load your data into power BI using Get Data ( there are 180+ sources from which you can fetch data) then click on transform and open power query editor.
In the power query editor you can perform your sampling task by using grouping feature and create a reference table by right clicking on the sampled query.
Click Close & Apply to load your sampled data into Power BI.

Since Power BI can refresh data from the source automatically, your sampling process will update each time the data is refreshed. You can even set up scheduled refreshes in the Power BI Service to keep everything up to date without lifting a finger.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Viki_5]

Hi @anmolmalviya05 , So I sample the data weekly, So I can have conditions where the sampling is done for the current week, No I'm trying to automate the process, where I have a table, And on clicking a button, I want the sampling to happen automatically and produce another table. Are you sure this can be done? I don't want to move to the query editor everytime i want to sample some rows. Thanks for your help, really appreciate it.