Hello,
I would like to start using and tracking comments in one of my projects. The dataset contains information about sales to our customers. The important columns are Customer Name, Order Number, Month, Gross Sales Value.
Process flow:
* One excel file per country on a monthly basis saved on SharePoint (files are named YYYYMM_Country = 202110_Finland, etc.)
* Power BI connects to SharePoint folder
* Power BI has a daily refresh schedule from SharePoint
* Approx. 1,5M rows (aggregation = order number level)
What I would like to do is to create a Power App which will allow users to enter comments.
The data point for which the comments will be entered will be on a Customer & Month level (user selected which month and which customer and enters comment in the text box). I don't want to have comments on the invoice level. If I aggregate the table to the Customer Level & Month level, I will end up with approx 300k rows.
My question is... how do I prepare the file/source data for the comments? Ideally, I would create excel connected to Power BI Dataset, but this is not possible. SharePoint list seems to small... I don't have a SQL Server either. Is there any workaround for that?
