We are installing to Sandbox environment and everything was going good until late last week. The current issue is that after we publish to the Sandbox successfully with changes to our APIs. We go to access the API in Power BI using the BC connector but we cannot see ALL the APIs that were published. There are about 4 APIs that are not able to be seen and we have done everything to troubleshoot the issue by renaming the file, change ID number, and other things without avail. Has anyone else encountered this issue? What is the cause of certain API not being seen while others are fine using the BC connector. All these queries were being seen in Power BI a few days ago along with changes, etc. So not sure what happened.
I even duplicated the queries and only the queries that are already being seen in Power BI were duplicated (with different names, etc). Any help would be appreciated.