Solved: Sharing ODBC connected file

Patr5 · ‎12-27-2018

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 · ‎01-07-2019

Hi @Patr5,

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

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

v-frfei-msft · ‎12-30-2018

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

v-frfei-msft · ‎01-07-2019

Hi @Patr5,

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

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Patr5 · ‎01-26-2019

Frank

Yes this will work, thanks for the help

Sharing ODBC connected file

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024