Power BI Report Builder - OSI PI SQL Client or OLE DB connector not available
I am currenlty migrating SSRS reports to Power BI service. SSRS reports connects to OSI PI system through OLE DB connector. As I am updating my rdl files in Power BI reports builder I am not able to find similar connection type or any alternative which could work for me. I could easily connect to the data source through normal Power BI report but Power BI reports builder does not support this. If anyone has created paginated reports connecting to OSI PI system please help.
Paginated Reports Rendering Extremely Slow
I am trying to explore Paginated Reports in Power BI using the following steps: 1. Created data source using Power BI Dataset connection. 2. Created a simple table on Power BI Report Builder. 3. Render the report using "Run" button. The report rendering was extremely slow. So I tried the following: 1. Created Data Source using SQL Server database connection. 2. Created a simple table on Power BI Report Builder. 3. Render the report using "Run" button. The report rendering was again extremely slow and eventually gave me system.outofmemoryexception. Please pour in suggestions to deal with this slowness. I really want to explore Paginated Reports in POwer BI.