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.
Hi,
I tried to import the excel file into the power bi, the excel file contains few 10 tables with less than 100 columns all put together.
Rows are 600 nos per table. But I get the below error message saying the number of columns in your data model exceeds 16000 limit set in options. How to resolve this?
.
Solved! Go to Solution.
Does providing the same name to sheet and table creates a conflict?
Yes. If you have a tbale name with the same name as you sheet, when connect to this excel file, Power BI will rename your table name.
Regards,
Charlie Liao
Are ther any blank columns or hidden column in your excel table? You can open a new excel file, and copy the columns and rows from RetirementGoal to new excel file, and check if this issue persists or not.
Regards,
Charlie Liao
Hi, I went to query editor in PowerBI Desktop and noted in the table it has reference to the entire sheet in the formula bar, then realized that I have selected the sheet instead of the table because the both the sheet and table got the same name. Surprisingly, table with the same name is not reflecting in the Get Data process. Does providing the same name to sheet and table creates a conflict?
Thanks for your reply.
Does providing the same name to sheet and table creates a conflict?
Yes. If you have a tbale name with the same name as you sheet, when connect to this excel file, Power BI will rename your table name.
Regards,
Charlie Liao
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.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |