We are interesting in using Power Pivot/Query/BI without having Assets ..straight from the Data Archive.
We know it's better to achieve an Asset Hierarchy and then move on to Power applications but we are still away from having AF structure in our database.
Has anyone tried to "bypass" AF and went straight to Power BI and Dashboards from the Data Archive?
What are the steps? Where should we begin? How do we establish the integration/connection between BI-Data from PI Points?
Thank you in advance!