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.
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.
Thank You so much for your help