Power BI supports only the .NET Framework OLE DB Provider for ODBC and does not support the Micrsoft OLE DB Provider for ODBC (MSDASQL).
If you create a Data Link file such as this one (ExcelNov.udl) I created from an EXCEL file:
Provider=MSDASQL.1;Persist Security Info=False; Data Source=Excel64Test;Initial Catalog=C:\USERS\OWNER\DESKTOP\BLOG2017\MSSS2017\suiggy.xlsx
You cannot connect to EXCEL file using the Connection string such as the above. First of all, it does not support the attribute, Persist Security Info=false. Even if you remove this attribute, you will not be able to connect.
Review the following screen shots attempting to connect to EXCEL file using its Data Link, ExcelNov.udl.
Accessing the OLDDB option in GetData.
Using the connection string:
If you create a Data Link file such as this one (ExcelNov.udl) I created from an EXCEL file:
Provider=MSDASQL.1;Persist Security Info=False; Data Source=Excel64Test;Initial Catalog=C:\USERS\OWNER\DESKTOP\BLOG2017\MSSS2017\suiggy.xlsx
You cannot connect to EXCEL file using the Connection string such as the above. First of all, it does not support the attribute, Persist Security Info=false. Even if you remove this attribute, you will not be able to connect.
Review the following screen shots attempting to connect to EXCEL file using its Data Link, ExcelNov.udl.
Accessing the OLDDB option in GetData.
Using the connection string:
Removed the Security Information and trying to connect.
The ExcelNov.udl file is OK and the connection is successful but not for Power BI.
No comments:
Post a Comment