Re: Which one is best for PowerApps application?
Hi @Anonymous ,
For your first question, I think the SharePoint list would be a better choice for you.
Currently, within PowerApps, the Teradata connector is not a delegable data source. So you could not delegate the data process from your app to your Teradata table, instead, you could only, process data locally within your app.
In default, you could only process 500 records locally in an app. You could change the "Data row limits for Non-delegable queries" option to maximum value -- 2000, then you could process 2000 records in your app locally.
With SP List, you could apply a delegale formula to your SP List data source, then it could delegate the data process from your app to your SP List itself, to improve your app's performance.
More details about Delegation in PowerApps, please check the follownig article:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
For your second question, I think Power BI would be a better choice for you. Power BI report has a good integration with PowerApps canvas app. You could display Power BI report within a canvas app using Power BI Tile control. You could also consider embed an canvas app into a Power BI report using "PowerApps Custom Visual".
In addition, Power BI could connect to more abundant data sources (e.g. Azure Blob Storage, Github, ... etc) than Tableau.
Best regards,
