The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Dear all,
I kept receiving the following errors when I refresh my dashboard, can someone advise and assist?
I have many rows and columns and all entered by various parties, I cannot re-enter those data one by one, it will be time consuming...is there any way I can narrow down the column and row that is causing the error?
Thank you.
Best regards,
Bliss
Solved! Go to Solution.
@Bliss , You have a table on one side of one-to-many relationships. That is a blank or duplicate value. check that.
You can filter null in power query and remove duplicate in power query, for the master table
Hi @Bliss ,
- Data source errorColumn '<pii>Date Period</pii>' in Table '<pii>Operations</pii>' 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: Operations.
Based on the error message, please check table "Operations" and its column "Date Period" and remove blank values.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Bliss , You have a table on one side of one-to-many relationships. That is a blank or duplicate value. check that.
You can filter null in power query and remove duplicate in power query, for the master table
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
112 | |
69 | |
46 | |
43 |
User | Count |
---|---|
186 | |
85 | |
76 | |
74 | |
56 |