Can I use a "View" instead of using "Table", while developing a Data Entity?

(1) Share

Report

Posted on by JJDunaid

226

I have to Develope a data entity can I use /view/ instead of /table/?
If /yes/ then what will be the impact of view on performance? will it enhance the Performance of response time for the Power Apps?

Actually I have been developing this entity for power apps.

any suggestions?

I have the same question (0)

All responses (7)

Answers (1)

Martin Dráb 237,668 Most Valuable Professional on at

Like (0)

Report

Can I use a "View" instead of using "Table", while developing a Data Entity?

You're asking in the AX forum, but I suspect that your question may be about F&O. Is it so?

If so, you can use a view, but it won't have any impact on performance, if you still run the same query. Just putting the query to a view doesn't change the query that needs to be executed.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Can I use a "View" instead of using "Table", while developing a Data Entity?

Hi Junaid,

I think View won't show as the datasource when you create new entity.

To overcome that you need to select some tables - Create entity and then change the DataSource property to your custom view.

Thanks,

Girish S.

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report
Can I use a "View" instead of using "Table", while developing a Data Entity?

Hi Martin ,

Hope you are doing well ,

Yes, it's in Finance and operations.

I am not using any query in view but I have created view using table as Mr. GirishS have told already.

So, if you got my problem what would you suggest me ?

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,668 Most Valuable Professional on at

Like (0)

Report

Can I use a "View" instead of using "Table", while developing a Data Entity?

Moved to the right forum.

A view must make a query to fetch data. When you say "I have created view using table", it means that the view uses a query to fetch some fields from the table. You probably meant a named query in AOT when saying "I am not using any query in view", but I mean a database query in general.

For example, if the query is "select Field1 from Table1", it'll still be the same query if you wrap it in a view. And because it's the same query and the work that the DB server must do will be the same, performance will be the same too. It's not something that can help you with performance. You'd need to either run a different query, or improve how the query executes (e.g. by adding a missing index).

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report

Can I use a "View" instead of using "Table", while developing a Data Entity?

Ok, I totally got you in simple there is no major difference in performance.

I have another scenario ,If I have created an entity adding five fields from table ! and I have to add one more field "sixth field" in the entity.
what will be the procedure to add field from table ?
Do I have to recreate the data entity or is there any other way through which I can add new field in the entity Datasource fields and staging table?

Was this reply helpful? Yes No
Martin Dráb 237,668 Most Valuable Professional on at

Like (0)

Report

Can I use a "View" instead of using "Table", while developing a Data Entity?

Please don't change the topic. This thread is about Can I use a "View" instead of using "Table", while developing a Data Entity?; please create a new thread about adding fields. It'll be easier to understand which answer belongs to which question, whether the question was answered, what is the verified answer and so on.

Was this reply helpful? Yes No
JJDunaid 226 on at

Like (0)

Report

Can I use a "View" instead of using "Table", while developing a Data Entity?

Sure.

Thanks Martin

Was this reply helpful? Yes No

Join the conversation

Community site session details

Can I use a "View" instead of using "Table", while developing a Data Entity?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Can I use a "View" instead of using "Table", while developing a Data Entity?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates