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.
The table in Excel has data:
However, in PowerBI, for some reason, it decided that I want null for everything except the first row:
I checked in Excel to be sure the data type is constant for each column, but still PowerBI wants these rows to be null. Notice that sa couple values came through, but things like Date certainly didn't. What should I start investigating? This kind of thing seems to happen every quarter, and I end up just importing again to create a duplicate table in PowerBI and it works fine. I have so many duplicates now, it's a pain.
I've got the same issue with files pulled from Oracle (EAS). The short term solution is opening those files in Excel and just saving them. Long one, TBC.
hi @utnapishtem
You may try use ctrl+T to create a table then load into power bi
Regards,
Lin
@utnapishtem , Under Data Transformation, there is an option to delete blank rows. Delete those rows and check you might have other rows.
There is an option Delete rows under that delete blank/empty rows
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks for the pointer to the advanced editor! It helped me find my mistake that caused the issue - I saw the data source in there was pointing to a OneDrive location that didn't exist on this machine.
However, after that was fixed, none of the data would load because for some reason, PowerBI decided to create relationships between same named columns in completely different tables. I had to cool down for a while before I came back to avoid damage to my PC. I deleted every relationship that was automatically created and things are working again. Every quarter, some new problem caused by PowerBI, and a few caused by me, I guess.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
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 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |