From your description, it seems that you share the pbix file with end users, right?
As the end users have 32bit ODBC driver, please let the user create a 32bit DSN. Install the 32bit Power BI desktop, open the report you shared, go to data source settings, change DSN name to his 32bit DSN.
Personally, I would suggest you publish your pbix file to Power BI service, then create a ODBC data source under on-premise data gateway, configure the dataset to use this data gateway, share reports follow this article.
Best Regards, Qiuyun Yu
Community Support Team _ Qiuyun Yu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.