Forum Discussion
Sharing ODBC connected file
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
Hi Patr5,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank
3 Replies
- v-frfei-msft
Community Support
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
Community Support
Hi Patr5,
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Regards,
Frank- Patr5Regular Visitor
Frank
Yes this will work, thanks for the help