Sharing ODBC connected file

[Patr5]

I have an Excel power query file that links to an ODBC connection to an ERP database.  I would like to share this file with several users who do not have an ODBC connection. It errors out when they try to refresh the Excel power query file. Do you have any recommendations on how I can accomplish this? Thanks

[v-frfei-msft]

Hi @Patr5,

I suggest your to connect to the data source using Power BI desktop and publish the report to service. Then you can share the report to others. For more details, please check the online document.

Regards,

Frank

[v-frfei-msft · Accepted solution]

Hi @Patr5,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[Patr5]

Frank

Yes this will work, thanks for the help