Forum Discussion
3CX Report Import
I don't know 3CX specifically, so whether you can directly get the data from them I wouldn't be able to comment. That would entirely depend where the data is stored and what access you have.
Power BI can check back with a source either Daily or Weekly.
Getting it to remove the Top X rows is easy, as i described. Getting rid of the last row could be done by using the "Filter Rows" option and using whatever is unique about that last row to remove it. Something like a column where it is always null, but not null in your data. Or if its labeled something like "Grand Total", you could filter out specifically by that.
Good evening,
It's an old thread but what i did is create a logic app which downloads the scheduled csv file to a file server. On this file server there is a script which imports the information into a SQL database. This happens every night.