Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.