2 of 2 people found this helpful
Let me just initiate the conversation.
PI Integrator for Business Analytics is the recommended product for integrating PI data into Tableau. PI Integrator for Business Analytics presents PI System data suited to business intelligence tools like Tableau for reporting and analytics. Business Intelligence (BI) client tools offer the ability to run retrospective analyses on a much larger set of your real-time PI System data.
WDC Tutorial talks about building an application that connects to the web endpoint feed (here USGS) and downloads data.
You can test with replacing the jQuery $.getJSON URI with a PI Web API endpoint. You might have to edit the table schema according to the items returned by the endpoint.
We recently bought the Integrator. While the integrator has its challenges, it plays well with Tableau and PowerBI. If integrator is not an option at the moment, can you not use OLEDB Enterprise and populate SQL Tables and then consume the data in a BI tool?