on
RE:
This should definitely be implemented in PowerBI.
RE:
This is a necessary feature in order to allow end users to create reports. Maybe a feature similar to Qlik, where users can use a measure formula (DAX) in a visualisation, without actually creating a named measure.
RE:
Comment: Credit note is not considered as payment with due date. So credit notes are not reported on Payment deadlines report.
if invoice is fully settled by credit note, this invoice will also not be reported
RE:
This would be really helpful in cleaning up the vast amount of unused group-based Power BI workspaces.
RE:
Great addon for the user.
RE:
When it's possible to maintain versions in a SharePoint library, it seems silly that this feature doesn't exist in PowerBI yet.
I'd expect to see a tenant level setting that would allow us to set a value for “x” number of versions to retain.
Workspace admins should then have the ability to see data and time of change to reports/dashboards and reinstate an older version if needed.
RE:
Disallowing the date filter for Calculate Inventory presumes a perfect world. Assume that we’re old hands and getting ready to close 08/31/20 timely. In this scenario, our prod-ops people would be taking inventory today and uploading their physical count to SharePoint for accounting to retrieve. The way Microsoft is envisioning this, we should enter the second the physical count is uploaded, and MSBC will calculate difference. Until we automate, that difference is our monthly usage. Post-automation, the difference will be shrinkage.
This reasoning fails on two levels:
1) Even if fully automated, there’s no accounting team that will have all PIs entered on the same date as physical count is taken. Even if I had a team of 50 accountants instead of 6, we would not have all invoices from our vendors, nor would we necessarily have all BOLs to enter incoming inventory.
2) Assume that accounting decides to wait until all PIs are entered and ensures that this occurs within 5 business days. During those 5 business days, business does not come to a standstill. Production-warehouse people will be entering BOLs. Posting physical count 5 business days later means that entries will have been made from subsequent accounting period, and those entries cannot be filtered out.
Microsoft’s assumption does a disservice to those of us who are trying to implement MSBC. We consolidate 23 different legal entities, multiple currencies, multiple business types – manufacturing, e-Commerce, software development, services. The complexity of our business model drove us to MSBC. But the way physical inventory journals are handled, Microsoft is assuming that every client enters every document the same day it is received and that prod-operations neither gets ahead of nor lags behind accounting.
Currently, physical inventory journal is designed for perfect world scenario, and that scenario simply does not exist.
RE:
My company also uses Deltek Vision and need to access & visualize its data via Power BI
RE:
Agree. Can also have impact on analysis view entries.
RE:
We really need to be able to download .pbix files for reports that have been created in the Power BI Service as well