Forum Discussion
Microsoft EmployeeCan't perform scheduled refresh when connecting Spark database directly to Power BI Report Server
pbinewbie101 wrote:
...do you know will the two options (1) use supported connector; 2) use ODBC ) have a huge impact of response time of data? I am asking because the customer has hundreds of millions of data going through everyday.
No, sorry I have no idea. You'd have to run some tests yourself and see. But that scale might be beyond what is reasonable for PBIRS. If you have to stay on premise I'd suggest looking at using an Analysis Service instance in tabular mode. Then you have the option of creating paritions so you don't need to pull through all the data every time you refresh. You can then create a Power BI Report in live connect mode point at SSAS.
Microsoft EmployeeHi d_gosbell ,
Thank you so much for your quick response. Really appreciate it.
Please bear me with another follow up questions - do you know will the two options (1) use supported connector; 2) use ODBC ) have a huge impact of response time of data? I am asking because the customer has hundreds of millions of data going through everyday.
Super User
pbinewbie101 wrote:
...do you know will the two options (1) use supported connector; 2) use ODBC ) have a huge impact of response time of data? I am asking because the customer has hundreds of millions of data going through everyday.
No, sorry I have no idea. You'd have to run some tests yourself and see. But that scale might be beyond what is reasonable for PBIRS. If you have to stay on premise I'd suggest looking at using an Analysis Service instance in tabular mode. Then you have the option of creating paritions so you don't need to pull through all the data every time you refresh. You can then create a Power BI Report in live connect mode point at SSAS.