Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
maartjedutchy
Frequent Visitor

Saving total count per month in table for YTD.

Hi everybody,

 

So I have been researching for a while but haven't really found a working solution, hope you can help me out. I am using a SQL database that stores a month worth of data (around 500,000 records) which I use as a dataset in PBI. Every month when I refresh I lose the previous month worth of data. However my client wants month to month visualizations to show trends, e.g. incoming volume per month over the year 2018.

 

Now I know there are workarounds to store historicial data in PBI using R script, but I don't really need to store the whole dataset. I only want to "save" the total volume of that month that I see in my created visuals and write back in a table, so I can build up this YTD.

 

A current workaround I need to export the visualizations as CSV and paste the month values in an Excel sheet which I load back into PBI.  There are quite a lot of these YTD visuals in my report, so its very time consuming workaround and I really would like to automate this. 

 

Is there anyway to write or store these values? and not the whole related dataset?

Thanks for taking the time!

M

 

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

Hi maartjedutchy,

 

So your requirement is to export part of the dataset by PBI automatically, right? R script can save part of columns to a dataframe and then write them as a table to a .csv file or other formats.

Please refer to:https://community.powerbi.com/t5/Integrations-with-Files-and/Can-PowerQuery-write-data-back-out/td-p....

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

Hi maartjedutchy,

 

So your requirement is to export part of the dataset by PBI automatically, right? R script can save part of columns to a dataframe and then write them as a table to a .csv file or other formats.

Please refer to:https://community.powerbi.com/t5/Integrations-with-Files-and/Can-PowerQuery-write-data-back-out/td-p....

 

Regards,

Jimmy Tao

Hey Jimmy,

 

That could work! But I want to export data from visualizations not parts of a dataset. I guess I have to create the numbers my visualizations give me into a dataset and then use R script. 

 

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.