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.
* 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?
I see you mentioned you don't have an SQL server. By looking at this data I recommend having Azure SQL. Azure SQL server S1 (2 GB) is very cheap which is $4/month. We are using Azure SQL since PowerApps does not have a connector to Synapse.
PowerApps works well with Power BI embedded with SQL Server as backend
I have been doing writeback functionality for a few clients. And I have a few blogs for this.
Other Related blogs. Please let me know, I can provide more inputs.
Stalin - Learn To Illuminate
This makes sense... so, is this the only way to go?
The problem is that setting up a SQL Server in the Company I'm working in will take months and the IT will charge us thousands $ for setting this up... but these are internal issues on my end.
That's why I was looking for some easier/faster solution without involving IT. Nevertheless, what you provided is helpful. thank you!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.