cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
elinsner Frequent Visitor
Frequent Visitor

Historical Reporting with Salesforce and Other Systems

 

I am new to Power BI and would like to utilize it for historical reporting from Salesforce, Pardot, Google Analytics and a few other smaller systems.  From my initial testing and online research it appears historical reporting is only available if I create some type of Data Warehouse.  The data warehouse will allow Power BI to pull the info that it needs to create the reports and dashboards that I am looking for.

 

Can someone verify if this is true, and if so, what the preferred data warehouse would be to function as the go-between for these systems?

 

Thanks in advance,

 

Erik

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Historical Reporting with Salesforce and Other Systems

@elinsner

 

It's true. Since you need historical reporting for those online services data, you have to store the data somewhere so that you can keep the historical data of past periods and compare with latest data. You can try SQL data warehouse or some other data warehouse for this function.

 

Regards,

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Historical Reporting with Salesforce and Other Systems

@elinsner

 

It's true. Since you need historical reporting for those online services data, you have to store the data somewhere so that you can keep the historical data of past periods and compare with latest data. You can try SQL data warehouse or some other data warehouse for this function.

 

Regards,

Highlighted
oliverhansen Frequent Visitor
Frequent Visitor

Re: Historical Reporting with Salesforce and Other Systems

It is possible to do this ny using the reporting snapshots feature in Salesforce