Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Power Bi Community,
I'm new to Power Bi, but was able to develop a report in PowerBi Desktop using data from Excel File saved in OneDrive. However, after completing the report, I realized that I needed to add two extra columns in my Excel file. I'm now trying to update my data in PowerBI after adding the columns in the original Excel file, but I can't see the columns. I tried changing the data soource from data query, but nothing. Any tips on how to do that?
Thanks!
Solved! Go to Solution.
If there is a step where a table is expanded to display the columns, open that by clicking on the gear cog. Do you see the two new colums in there? If so, click the check box and they should now be avialable.
If not, how are you connecting to the data in the Excel file, via a Sheet, Table, Range?
Cheers
Hi @natahoughton ,
Please refesh the data in power query as the picture below.
If there is a step where a table is expanded to display the columns, open that by clicking on the gear cog. Do you see the two new colums in there? If so, click the check box and they should now be avialable.
If not, how are you connecting to the data in the Excel file, via a Sheet, Table, Range?
Cheers
Can you please explain what did you mean by "where a table is expanded to display the columns, open that by clicking on the gear cog"?
I have the same issue when I import several tables from a folder with the same number of columns and the same type of columns in each imported table.