Unable to Update SQL Server connection in Power Query for Mac

[BourbonCoffee]

Hello!

I've connected to SQL Server in an Excel in Power Query. There are 2 new tables available, but for some reason on a mac computer those aren't showing up.

But if I'm to refresh it on a Windows PC it shows them all:

I'm using same credentials, and I've already tried:

1. Delete connection permissions on the mac pc and put in credentials again.

 2. Delete Excel cache on mac pc. ~/Library/Group Containers/UBF8T346G9.Office/User Content/Startup/Excel

I haven't tried reinstalling Excel on mac. However, I don't want to try this approach for this is happening in all mac pcs and new tables are likely to be. 

If you know the answer, you really are Maestros, I appreciate your help. 

[v-stephen-msft]

Hi @BourbonCoffee ,

This problem might be related to remote connections.

You can use Azure Data Studio, which is a lightweight management tool for managing SQL Server and is available for macOS, Linux, and Windows. Please refer to

macos - How to connect SQL Server on mac - Stack Overflow

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Mahesh0016]

@BourbonCoffee I hope this helps you. Thank You.

It's frustrating when you encounter issues like this, but there are a few steps you can take to troubleshoot the problem with Power Query not showing tables correctly on a Mac. Here are some suggestions:

1. **Check for Excel Updates:** Ensure that both Excel and Power Query on your Mac are up to date. Sometimes, issues are resolved in newer versions, and updating might fix the problem.

2. **Review the Query:** In Power Query, make sure the queries are constructed correctly. Check if there are any filters, conditions, or settings that might be causing the tables not to show up on Mac but work on Windows. Review any custom queries or transformations that might be applied differently on each platform.

3. **Check Compatibility:** Verify that the SQL Server version you are connecting to is compatible with both Windows and Mac. Ensure that there are no specific SQL Server features or configurations causing the discrepancy in table visibility.

4. **Verify Permissions:** Double-check the user permissions for the SQL Server database. Ensure that the user account you are using on both platforms has the necessary permissions to access and retrieve the tables you expect.

5. **Test on Different Macs:** If this issue is occurring on multiple Mac computers, try it on a completely different Mac machine to see if the problem persists. This can help determine if it's a system-specific issue or a broader problem.

6. **Compare Data Sources:** Compare the data source settings and connection properties between the Windows and Mac installations of Excel. Make sure they match exactly, including the authentication method, server address, and database name.

7. **Check for Mac-Specific Limitations:** Unfortunately, sometimes there can be platform-specific limitations or bugs in software. Check Microsoft's official documentation or community forums to see if there are any known issues with Power Query on Mac that could be causing this problem.

8. **Contact Support:** If none of the above steps resolve the issue, consider reaching out to Microsoft support or your organization's IT support for further assistance. They might have insights or solutions specific to your environment.

Reinstalling Excel on your Mac should be a last resort, as it can be time-consuming and might not necessarily resolve the problem if it's a compatibility or configuration issue.

Remember to back up your Excel files and any custom queries or transformations before making major changes or reinstalling Excel to avoid data loss.

[BourbonCoffee]

I've checked on multiple macs. Once you connect, the query is not calling any other new table. But in any other Windows it does. Only thing left is contacting support.

Thanks for your response.