Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Good
I'm updating a report that we use to see monthly and yearly sales.
The problem is that we have just opened a new boutique and we are already selling in it. I have added this boutique to the excels from which my BI report is nourished. But for some reason, it can't find the new boutique and therefore I can't add it to the total sales.
I attach some screenshots in case they could help;
In this screenshot we will see the points of sale that the application currently reads to me.
And here is the boutique in the Excel from which the report is nourished;
Well, for some reason which I do not know, this boutique is not shown in my PowerBi report.
Any help will be welcome.
Thank you
Greetings,
Mario F
Hi, @Syndicate_Admin
The screenshot above is not too clear, a clearer screenshot would be nice.
Based on what I got, you are using two table fields in the report, if you still not get the new boutique after refreshing the data, then it must be something about the relationship between the two tables and fields of table
It would be helpful if there were more details here. And It would be great if there is a simple sample file without any sesentive information here.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MarioF
Seems to me that you are missing the store in some table that you need in your model without access to the model is difficult to pin point the error.
But on a previous report I saw the user forgot to add the location to another table that was not brought from the excel and databased but was made in some other way in Power BI.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThe Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 48 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 198 | |
| 126 | |
| 102 | |
| 67 | |
| 50 |