Power BI

Resolved · Medium Priority · Version 365

Thu 3 Feb 2022, 10:21 Delegate Elena-may said...

Elena-may has attended:
Excel Advanced course
Power BI Reporting course

Power BI

Hi, I use Quickbooks and have noticed that Power BI doesn't pickup the column names, it moves the headers to row 1. I've tried to transform the data but that doesn't seem to work but can you please help with this? Thanks

Thu 3 Feb 2022, 14:48 Trainer Jens said...

RE: Power BI

Hi Elena-may,

Thank you for the forum question.

Did you use the tool "promote first row to headers"?

When you wrote "but that doesn't seem to work", what happened when you tried to transform the data?

I have never been working with data sets where I couldn't promote first row to headers.

I have been working with data sets where Power BI couldn't recognise the headers, but always been able to promote first row.

I have tried to Google the issue, but I cannot find any information about the issue you have.

I am sorry, but it is very difficult to help you with this question.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

General Shortcuts

Ctrl + S: Save the report or dashboard.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last undone action.
Ctrl + C: Copy selected items.
Ctrl + X: Cut selected items.
Ctrl + V: Paste copied or cut items.
Ctrl + A: Select all items.
Ctrl + N: Create a new report or dashboard.

View all Power BI hints and tips