Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |