Forum Discussion
PowerBI Double Counting my data
When I import data from a folder containing multiple excel documents it is double counting my data. So in other threads this has been said to be a rare bug but it happens to me almost everytime I get...
Anonymous,
After you connecting to the folder in Power BI Desktop, why not directly expand the content column to get combined data of all excel files?
In your scenario, if you create table in a Excel sheet , Power BI will double count data((both sheet data and table table)) using the above power query code.
Regards,
Lydia
Anonymous,
After you connecting to the folder in Power BI Desktop, why not directly expand the content column to get combined data of all excel files?
In your scenario, if you create table in a Excel sheet , Power BI will double count data((both sheet data and table table)) using the above power query code.
Regards,
Lydia
Seems to work pretty well. My orginal solution was created after watching this video: