Forum Discussion
Connection to database not returning current data in power query but does in MS Query
I have an excel SS that uses power query to provide a report with a connection to our accounting system. We have a new employee and they have been set up with rights to the odbc connection. Howev...
Hi AGray
What is the data source type of these files? How did the new user connect to these files in Power Query?
It may be due to the connection of the query. You can go to Data > Existing Connections to verify the connections in the current workbook. If a connection is not configured correctly, you can right click on the connection and click "Edit Connection Properties..." to configure it. Remember to verify the "Authentication Settings" in Definition tab.
Best Regards,
Community Support Team _ Jing