Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I wanna get rid of the tables which I used to combine the data but after applying it, it loads all the tables but that's not what I want since it is time-consuming to load the duplicated tables which basically lead to redundancy and affects the efficiency of the report.
I tried to delete them but due to referencing, I am unable to delete or remove those tables or sheets.
is there any way to achieve the same or it's not possible. Please guide me through this issue.
any help and suggestion would be great.
Solved! Go to Solution.
Hello Sid25,
You can disable 'data load' or 'Include in report refresh' in Power Query (right click on the query) . If you disable this it wil not be shown in the report but the 'combined' table will work as it should.
Hi @Sid25,
You cannot delete a query that is referenced by another query. In your case, jan1, jan2, jan3 and feb are all referenced by combined. You may do what @Erk has suggested. This will not load those queries into your data model and will not take up space.
Proud to be a Super User!
Hi @sid,
Go to Power Query . Right Click on the table you dont want to load in the data Model.
Disable the Enable Load. Tick Mark should be removed.
Regards,
Harsh Nathani
Hello Sid25,
You can disable 'data load' or 'Include in report refresh' in Power Query (right click on the query) . If you disable this it wil not be shown in the report but the 'combined' table will work as it should.
@Sid25 , have you combined them in edit query. Because if you have done in edit query/data transformation mode then you delete or hide those.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |