question

AchinGupta-8310 avatar image
0 Votes"
AchinGupta-8310 asked DSPatrick answered

Need a quick solution for a Power BI - Extra Static Column Headers

I am working on a Power BI Report to bring my tabular data to the UI Table. When I export the table data then I get all the Table headers as Column Headers along with a subsequent list of records down there in exported excel.

I would also need above Two Headers as fixed everytime when I export the data into excel.

Green Colored Headers are already there from exported table data but are not able to add above two headers on top of it as customer requirement.

Row1: Jobpac - Delivery Dockets Upload
Row2: Delivery Docket Date DDMMYY Defaults to current date Delivery Docket Number MANDATORY Blank or Y if deletion required Quantity 4 decimals allowed MANDATORY PO Work ID MANDATORY Purchase Order MANDATORY Purchase Order Item MANDATORY Free Format Text Max 20 characters Job Workid OPTIONAL Job No OPTIONAL Cost Code OPTIONAL Cost Type OPTIONAL Activity Code OPTIONAL Asset No OPTIONAL Asset Cost Type OPTIONAL Account No. OPTIONAL Stock Code OPTIONAL Warehouse No OPTIONAL Conformance Indicator NCR No Reason code Used by the Upload Process

Row3: Docket Date Docket Number Deletion Flag Quantity PO Work ID Order Item Comments Job Wkid Job Cost Code Cost Type Activity Code Assest No Asset Cost Type Account No. Stock Code Warehouse No

Please suggest any solution or way around to get the required excel format.

not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.