Forum Discussion
Archiving data
Hi Anonymous ,
"With the lack of a true UCCX interface, I have a bodged process that outputs the data from the Cisco Phones to a SQL table on another server."
Did you mean that because Power BI does not have a UCCX interface, so you transfer data to SQL tables and then connect?
There are two ways here, one is to use a custom connector .
And the other is to find a way in your data source, as long as the data source can archive the data, you can get what you want in Power BI.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Lionel, I say true interface, because there is a beta Informix interface, but it only appears to do 64bit, while Cisco is only 32bit. So BI throws an error.
Hi Anonymous ,
Are you using this connector?
"so I was wondering if there is a way to stop the data writing on an existing row when the date does not match what is there already and make it jump to a new row?"
Your problem has nothing to do with the connector, this involves data update problems.
In Power BI, M and DAX is used to transform and model, so maybe you can try to use SQL to achieve it.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No, I'm not, the Cisco system is 32bit and that connector is only 64bit. Through a bit of gouing around the houses, a utility converts the data to SQL and then the one line is sent out as a csv to a folder on another server. So all I have is the csv which gets overwritten every 5 seconds, until 23:59:59, then it resets for the new day.
The plan at the moment is to get our data warehouse to make a SQL table that picks up these csvs after 6pm after the helpdesk is closed, and build up the history that way, but I was looking for a solution not involving a third party, which just complicated this mess even more.