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
I'm getting this error when trying to refresh my dataset:
Column 'date' in Table 'Budget' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: Budget. |
I have tried everything I could find on the forum, importing the "budget" table to my report again and nothing is working - and there is no blank in the data to start with.
Furthermore, there is no problem when I refresh the data on the desktop version and I can upload it fine.
All suggestions are welcomed
Alexander
Solved! Go to Solution.
Hi @AlexanderAT,
It would not throw error if you clean trailing and leading spaces in your data in PQ Transformation.
Hope this helps.
Thanks,
Bhavesh
Got me on the right path... thank you!
Hi @AlexanderAT,
It would not throw error if you clean trailing and leading spaces in your data in PQ Transformation.
Hope this helps.
Thanks,
Bhavesh
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 |
---|---|
9 | |
5 | |
4 | |
3 | |
2 |
User | Count |
---|---|
12 | |
9 | |
7 | |
2 | |
2 |