I'm a new user.
I have a database with many tables. The database is created and updated with Clarion Topspped. I can easily read and create reports in Excel using an ODBC driver that has been installed on my Windows machine. I can also get data using Access. But the same workbook can't find the tables with Power Pivot, even though it says that the connection was successful, and Power BI Desktop won't connect at all (perhaps because it is trying to write to the database). It is very frustrating to be able to connect easily with Excel and Access and to be completely stymied by Power Pivot and Power BI Desktop. Surely this is not a new phenomenon, but I"m not seeing others with the same question, so maybe I'm just asking wrong.
Do you create dsn for the Clarion Topspped data source with the help of ODBC driver ? If you have created the dsn, you can use ODBC connector in Power BI Desktop to connect to it and import data from required tables.