Hello Experts,
I have a question on building a data model for a Power BI report.
I need to build a Power BI report using Denodo views as a source. These Denodo views are required a mandatory Date parameter pass in to query. Our Power BI report required a lot of historical data (last 60 days + 24 month ends). What would be the best approach to load all the data from Denodo views into Power BI? If it’s too much of a process, what would be the ideal solution for this. These base Denodo views are querying 3 different source systems and it has a fairly large data about 20M, also we have 3 different view that we need to load into Power BI.
the etl team is not ready to remove the Date parameter from views saying these queries might crash the Denodo server to load all these historical data.