Forum Discussion
SharePoint Online with ODATA Connection to BI Tools
By URL connection string samples, you mean just examples of accessing the OData? If so, this https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service has a number of examples. Again, the trick is to simply paste the URL in chrome. Other browsers will certainly work, but the other browsers assume you don't want to see raw data and either prompt to have you download a file or try to hide it from you. Chrome just shows the raw data. For example, your URL with lists/getbytitle is fine, and will return all the list items (or, the first batch if there's a lot of items).
I would be interested in looking at the URL connection string if you had some examples? I know they may not be the same, but it might spark some ideas. Unfortunately, we are not licensed with PowerBI to publish content and the goal was to create a project tracking cockpit published to the web for ease of access, using Business Objects. This was a way to put some analytics to how we spend our time. Are we hitting target dates, what types of projects are we working on, etc. A way to expand the Business Objects' package of value by integrating with SharePoint. Thanks again for sharing your knowledge, Michael!
By URL connection string samples, you mean just examples of accessing the OData? If so, this https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service has a number of examples. Again, the trick is to simply paste the URL in chrome. Other browsers will certainly work, but the other browsers assume you don't want to see raw data and either prompt to have you download a file or try to hide it from you. Chrome just shows the raw data. For example, your URL with lists/getbytitle is fine, and will return all the list items (or, the first batch if there's a lot of items).
For now, I'm going to mark it as lost functionality between Microsoft and SAP for migrating office to the cloud. I've had our 365 administrators do the same test and still no luck withing the Information Design Tool. I'll try the same tests after we upgrade Business Objects to the latest SP. Thanks again for all of your help, Michael!