Hi all ,
i would like to ask you a question.
i have created a duplication of Sales Cube in Dynamics 365 FO,to add some extra fields on the CustinvoiceTransExpanded ( View ) /custinvoiceLine(Measure Group) like the DefaultDimension and the InventTransId.
After Adding the fields to the Extension of the CustInvoiceTransExpanded and creating a new Aggregate Dimension for the table, building and synchronizing the tables and deploying to the test Environment, a new table on the SalesCube appears under the name SalesCube_CustInvoiceTransExpanded
i deployed the report inside Dynamics 365 ( Power bi embedded) and the deployment was succesful.
i created a new workspace , added the report catalog to this workspace , i receive an error "QuerySystemError" on every report containing fields from SalesCube_CustInvoiceLines // CustInvoiceTransExpanded.
My question is how am i supposed to edit the CustinvoiceLines On the salescube ?
and What should i do to show the data and remove the QuerySystemError on Dynamics ?
i admire your help
best Regards,
2 Comments
v-qiuyu-msftCommunity Support
PowerBiExp wrote:i created a new workspace , added the report catalog to this workspace , i receive an error "QuerySystemError" on every report containing fields from SalesCube_CustInvoiceLines // CustInvoiceTransExpanded.
Hi PowerBiExp,
Did you create a new workspace on Power BI service side or Dynamics 365 side?
What's the "report catalog?
If the issue happens after you embed the report in Dynamics 365, please check if the report can render fine in Power BI service firstly.
Best Regards,
Qiuyun Yuhi v-qiuyu-msft
i created a new workspace on D365 side.
report catalog is the power bi report opened in workspace d365;
do you have any document how to customize a table in a cube in dynamics 365 ?
appreciate your help
