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.
I have an Excel table at 4x8402. When I try to connect to this table all goes well until it gets to Creating connection in model bit where it just sits.
It would appear as though data is in the PowerBI table but I can do nothing with it.
Any suggestions?
Regards
Paul
If you have data model in your Excel workbook, you need to import it into Power BI instead of get data from Excel file.
Regards,
@Simon_Hou-MSFT wrote:
If you have data model in your Excel workbook, you need to import it into Power BI instead of get data from Excel file.
Regards,
Simon, thanks but this is a standard Excel worksheet. It just has too many colouns I beleive although all posts/searches I have done would suggest that 8403 colouns are not a problem.
So if I transpose the array to a 8604x4 array, it pulls in easily enough. It is the 4x8604 that is the problem.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |