By using this website, you agree to our Terms of Use (click here)
I've created a number of GIs for which I have the "Expose via OData" checked. When I go to Excel (I use Excel for Mac v16.72) and refresh the list they don't appear. Has anyone else experienced this and/or have you had luck refreshing the list of GIs? This is the screen in Excel I am using to see/refresh the tables in the "Get Data (Power Query)" Wizard. I was able to get it to work one time in a blank workbook, but I haven't been able to replicate it. Any thoughts would be appreciated!
Regards
Patrick
As a follow-up, 5 of the table in the list just disappeared and I have no idea why!
Did you confirm the security on the GIs - the OData user needs access to the queries.
When I've had this problem (and it was random, like you've experienced), unchecking Expose via OData, saving the GI, then re-checking Expose via OData and saving solved the problem.