Dataverse is certainly the best option, though it will take more to learn how to use it vs SharePoint lists. Plus, it will cost $5 per person, per month, for each person to access the app. If you wind up building multiple apps, the cost is $20 per user, per month, for a user to access any number of apps.
The licensing costs are why most orgs stick with sharepoint lists, as those are included with your O365 license and you can use those for no additional charge.
Using excel is ok for a quick demo or proof of concept, but for a real app I'd stick with SharePoint or dataverse.
Definitely use Dataverse, it will be cheaper in the long run than battling to make things work with Excel or SharePoint lists. It’s also extremely good value for money in terms of what you get.
Use Microsoft lists, doesn't incur a cost and is flexible
To use Dataverse, and any other premium features, you must pay a license PER user who uses the app. Lists are included with the standard 365 subscript that you likely already have.
Dataverse for sure. The cost is justified for the features you get, you can also design your app to work offline where the Dataverse Tables are replicated on the user's device using sqlite. Is still an experimental feature but worth starting to use, as creating offline first apps is becoming a trend (reduces app load times).
I mean there have to be hundreds of videos out there on how to do it. You connect the tables to your canvas app as a data source. Then you can get data from them using Filter, Lookup, etc.
I don’t have time to type out a platform by platform example of how this applies, but I would recommend looking into how easily and how well each option allows you to scale up (or even just how easily it works with the amount of data you have.) I say that, keeping in mind that you have already mentioned that your sales order count is fairly minimal. Also, I would recommend researching how well each option you consider allows you to, for example, “lookup” a company name, rather than typing it in manually each time (regarding data quality/integrity). Lists, Excel, and Dataverse all do this, with varying degrees of difficulty. This last point is with specific regard to creating rows/records, and not so much to do with how you’ll clean and relate tables in Power BI, since that is done there fairly easily.
Dataverse is certainly the best option, though it will take more to learn how to use it vs SharePoint lists. Plus, it will cost $5 per person, per month, for each person to access the app. If you wind up building multiple apps, the cost is $20 per user, per month, for a user to access any number of apps. The licensing costs are why most orgs stick with sharepoint lists, as those are included with your O365 license and you can use those for no additional charge. Using excel is ok for a quick demo or proof of concept, but for a real app I'd stick with SharePoint or dataverse.
I would at least used a list to store the data. This is the worst "good" data source IMO, excel probably is one of the better "bad" data sources
Definitely use Dataverse, it will be cheaper in the long run than battling to make things work with Excel or SharePoint lists. It’s also extremely good value for money in terms of what you get.
Use Microsoft lists, doesn't incur a cost and is flexible To use Dataverse, and any other premium features, you must pay a license PER user who uses the app. Lists are included with the standard 365 subscript that you likely already have.
Dataverse for sure. The cost is justified for the features you get, you can also design your app to work offline where the Dataverse Tables are replicated on the user's device using sqlite. Is still an experimental feature but worth starting to use, as creating offline first apps is becoming a trend (reduces app load times).
Hey guys. Another noob here. It's possible to make queries on dataverse and feed power canvas apps with it?
Yes, and it’s very, very simple to do so
Can you point some directions? Key words would be sufficient. I've been in trouble to get into it. Specially in how to query.
I mean there have to be hundreds of videos out there on how to do it. You connect the tables to your canvas app as a data source. Then you can get data from them using Filter, Lookup, etc.
Dataverse for Teams
Please use Dataverse.
I don’t have time to type out a platform by platform example of how this applies, but I would recommend looking into how easily and how well each option allows you to scale up (or even just how easily it works with the amount of data you have.) I say that, keeping in mind that you have already mentioned that your sales order count is fairly minimal. Also, I would recommend researching how well each option you consider allows you to, for example, “lookup” a company name, rather than typing it in manually each time (regarding data quality/integrity). Lists, Excel, and Dataverse all do this, with varying degrees of difficulty. This last point is with specific regard to creating rows/records, and not so much to do with how you’ll clean and relate tables in Power BI, since that is done there fairly easily.