Forum Discussion
Getting # in PBI Report
Hi Friends, We are implementing Power BI in our organisation as the reporting tool. The data source is BW4HANA. we are trying a PoC to establish we can build a hierarchies in PBI using BW Que...
HI Anonymous,
If you are working with direct query mode, the current power bi does not support your operation or replace the table records.
Did you work with the bw data connector? If that is the case, you can try to add a query in the advance option to filter or replacement on the result.
Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Docs
Regards,Xiaxoin Sheng
Are you sure there is no value in the rows for Node4? Or maybe an empty string is provided? Ideally you will want to replace that with NULL. Use a Power Query replacer (unless that is not allowed in your direct query scenario)