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.
Hi,
I have a data table "Temporary Data" which loads data from a website (dates for running past 90 days). One of the columns is a "date"
Then I have a data table "Data" which is supposed to:
- get all data from "Temporary Data"
- remove duplicates
One of the columns is "data"
"Data" table is connected to "dates" table while columns "dates" are connected...
I also have a time table.
But, when I hit a refresh button, there is an error since the Data" table contains a duplicates values
I need "something" which tells the POWER BI - "suppress the error" wait till the "Data" table removes duplicates and then keep the connections.
Thanks in advance for any help.
PR
Make sure you add a step to remove duplicate rows for "Data" table in Query Editor.
You must keep unique values in column used for building relationship.
Regards
Check to make sure there are no blanks. This often causes the error you are seeing.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |