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 am having an issue while switching a report with Direct Query to Import
Column 'Import' in Table 'Fact_Statistics' 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.
Import column is not the Primary Key, can the issue be caused by some key field not existing on One side?
Solved! Go to Solution.
Hi @dpombal,
I could reproduce your problem, if you want to create relationship between the two tables, you could delete the orginal relationship firstly, then try to import your data table and create the relationship, now you could get the result.
Hope it could help you.
Regards,
Daniel He
Hi @dpombal,
I could reproduce your problem, if you want to create relationship between the two tables, you could delete the orginal relationship firstly, then try to import your data table and create the relationship, now you could get the result.
Hope it could help you.
Regards,
Daniel He
So Starting with Direct Query, which is my usecase.
1. Direct Query Report with relationship between A and B
2. Delete relationship between A and B
3. Switch to Import
ok?
Hi @dpombal,
Yes, you could try this and if have any problems, please let me know.
Regards,
Daniel He
Hi , after Removing relationships,
problem still persists....
Column 'import' in table FACT contains blank values and this is not allowed for columns on the one side of many-to-one relationship or for columns that are used as the primary key of a table
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |