Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Syndicate_Admin
Administrator
Administrator

Help Outdated data in PowerBi

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.

MarioF_0-1636982597712.png

And here is the boutique in the Excel from which the report is nourished;

MarioF_1-1636982688050.png

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

2 REPLIES 2
v-angzheng-msft
Community Support
Community Support

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

vangzhengmsft_0-1637203268548.png

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.

MFelix
Super User
Super User

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.