What data source do you create ODBC dsn for?
I honestly have no idea - this is a corporate PC if that helps at all.
When trying to extract the data on to Excel I am going to:
From other sources
Kopen (the programme we use).
It's when I select one of the options listed below that it fails to work.
Do you create dsn for Kopen ? Have you tried the ODBC connector in Power BI Desktop?
Do you create a dsn named KOPEN? What is the original data source in the dsn?