Forum Discussion
Wonderware Historian Database
Andre-V,
In Power BI Service, it is not possible to store historical data. However, in Power BI Deskop, you can store historical data, for more details, please review the following thread.
http://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-using/m-p/207293#U207293
Regards,
Lydia
Andre-V,
Do you store the Wonderware Historian Database in SQL Server? If so, you can use DirectQuery mode to connect to the dataset in Power BI Desktop. DirectQuery is useful when you build visualizations over very large dataset, you can review this article to get more details about DirectQuery.
After you publish Power BI Desktop file to Power BI Service, you can add the SQL data source within gateway, as your dataset is configured for a DirectQuery connection, there is a direct connection between Power BI and the database, there is no need to schedule refreshed, and dataset is refreshed approximately each hour or when interaction with the data occurs. Moreover, bandwidth impacts the network, which will impacts the connection between Power BI and SQL data source, to ensure that the refresh process is as fast as possible, the connection needs to be as fast as possible, thus you need to adjust bandwidth based on your requirement. For more details about gateway workflow, please review this blog: http://www.fourmoo.com/2017/03/21/power-bi-gateway-infographic/ .
In addition, to connect to process Historian or Wonderware eDNA, you would need to contact Wonderware support to check if it has OData feed available or how to use its API to retrieve data, it is possible to connect straight to the OData feed from Power BI Desktop or use the web entry in Power BI desktop to connect to Wonderware API.
Regards,
Lydia
Hi Lydia,
Thank you for your reply, much appreciated.
The first two sections I am happy with.
For the 3rd I found that the Wonderware Historian can send data via OData.
The question I have if we link data to PBI Cloud and is dated for the last 24 hours if I update the same data set a day later will the previous day be lost or can we accumulate the data and keep the history?
Regards
Andre
Andre-V,
In Power BI Service, it is not possible to store historical data. However, in Power BI Deskop, you can store historical data, for more details, please review the following thread.
http://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-using/m-p/207293#U207293
Regards,
LydiaThis is GREAT thanks for sharing, I will test it out
