Forum Discussion
Add a record into PowerBi every month from existing data
I have limited experience regarding the 2 points you asked but I'll try to help in hope that someone else will second my opinion or just propose a better solution:
1. If you are using the service, you can subscribe to a report so that it will send you periodically the report by email. If you are using the server, you might need to develop a paginated report and a scheduled job. The scheduled job will run periodically to export the report using the report's URL and appended query strings to trigger the export functionality. Then the job will send an email with the report or just save it to disk.
2. Power BI doesn't write back to SQL but you can use Power Apps to develop an app that writes data to SQL.
Again, keep in mind that I might be wrong with my reponses above. Lets wait for someone else from the community to comment on this.
This looks more of a data engineering problem than a data analysis one. My understanding of Power BI is that it doesn't act as a database in which you can store values. You need to work this out in the data source. I understand your system overwrites the stocklevel but you have the CSVs files which you can use to your advantage. Probably save yesterday's generated CSV file somewhere and generate a new one for today instead of replacing yesterday's CSV with today's version. I have no idea what environment you are working on but you should be able to write a simple script that will copy the CSVs to a different folder which can be used for as Power BI's data source. It might be handy if the script also renames the CSVs to the date they were generated on.
Hi,
you're right in the base that this is an data engineering thing.
But I have also read here and there that Power Bi is able to "write back in SQL"
I'm not using SQL but maybe there are some possibilities to achieve what I want by altering such a method...
So actually there are 2 questions:
1.How can PBI generate automatically a datarow (or Report) on every first month.
2.And how could I write that back in SQL.
Edit: when thinking about that last one: if it is possible to write back in SQL, it should be easy to add a record in a (Enter Data) table in the same dataset...right?
If there's some direction I can take, maybe I can solve the prob...:)
I have limited experience regarding the 2 points you asked but I'll try to help in hope that someone else will second my opinion or just propose a better solution:
1. If you are using the service, you can subscribe to a report so that it will send you periodically the report by email. If you are using the server, you might need to develop a paginated report and a scheduled job. The scheduled job will run periodically to export the report using the report's URL and appended query strings to trigger the export functionality. Then the job will send an email with the report or just save it to disk.
2. Power BI doesn't write back to SQL but you can use Power Apps to develop an app that writes data to SQL.
Again, keep in mind that I might be wrong with my reponses above. Lets wait for someone else from the community to comment on this.