Power BI and OLE DB Provider MSDASQL

Power BI does not support the Microsoft OLEDB Provider for ODBC Drivers also known as MSDASQL.

Power BI uses the .NET Framework Data Provider of OLEDB (System.Data.OLEDB).

This was found while connecting Power BI to Microsoft Excel using the connection string developed using a (Universal Data Link) UDL file.

----------

[oledb]

; Everything after this line is an OLE DB initstring

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel7_11;DBQ=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam_old.xls;DefaultDir=C:\Users\Owner\Desktop\Blog2017\MSSS2017;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;";Initial Catalog=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam.xlsx

----------------------------

Also Power BI does not support the Persist Security Info attribute set to false.

This is the error message about OLE DB Provider support.

Which Provider provides faster performance while using SSAS 2008?

.NET Framework Data Provider of OLE DB works but the you could use any of the following:

1. Microsoft OLE DB provider for SQL Server
2. SQL Server Native Client
3..NET Data Provider for SQL Server(SqlClient)

The first two provide the fastet performance.