Forum Discussion

Aurelio's avatar
Aurelio
Frequent Visitor
4 years ago

Make model more efficient

Good day everyone   Currently all data is integrated via import into a single report. The data comes from Business Central or a Sharepoint. However, we thought it would be better to split the data ...
Need Help
ToddChitt's avatar
ToddChitt
Super User
4 years ago

Well, try a granular test of ONE table. Create TWO models: one a DIRECT QUERY and one an IMPORT. Creat the same visuals and slicers for testing. I think you will see that the IMPORT is going to out-perform DIRECT QUERY, especially if it is SharePoint. FYI, data sources such as SharePoint are NOT RDBMS, so when they go to filter data, they are not as efficient as SQL Server.

Direct Query is good if you have data that changes constantly and you MUST have up-to-the-minute results.

(I have seen 5000 record datasets take 5 minutes from SharePoint) 

But do your own tests, please.

  • Aurelio's avatar
    Aurelio
    Frequent Visitor
    4 years ago

    Good morning

     

    I'm not really concerned about the Sharepoint but if it is better to compose a dashboard with mulitple Directqueries that splitted up the original dataset or use 1 big import.