Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |