Forum Discussion
Getting # in PBI Report
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
Hi Ibendlin,
Thank you for your response.
Yes, there is no Value in Node4. In BW we cannot pass NULL to so the value will be empty where the is no Value in Node. Since we are usig "Direct Query" I am told that by the Power Bi resource that it is not possible to applying any transformation is PBI to replace empty value with Null. So want know if it is possible to replace # with blanks by doing some config/steeings instead of writing DAX?.
Regards
Naveen
Try using a measure to replace the Node4 values with BLANK()