Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

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

(1) ShareShare
ReportReport
Posted on by 208
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?
 
  • JJDunaid Profile Picture
    JJDunaid 208 on at
    Can I use a "View" instead of using "Table", while developing a Data Entity?
    Sure.
    Thanks Martin
  • Martin Dráb Profile Picture
    Martin Dráb 230,868 Most Valuable Professional on at
    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.
  • JJDunaid Profile Picture
    JJDunaid 208 on at
    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?
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,868 Most Valuable Professional on at
    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).
  • JJDunaid Profile Picture
    JJDunaid 208 on at
    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 ?
     
     
     
  • GirishS Profile Picture
    GirishS 27,821 Super User 2024 Season 1 on at
    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.
  • Martin Dráb Profile Picture
    Martin Dráb 230,868 Most Valuable Professional on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans