cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hhebbalu
Frequent Visitor

After the PowerBI desktop refresh, the fact/measure table icon is changing to regular table icon

Hi,

 

We save pbit in the source code. Whenever we need to make any changes in the file, we open the pbit file from the powerbi desktop and refresh locally and make changes save it as pbix.

After the refresh in powerbi desktop, the hidden columns are visible and the fact/measure table icon is changing to regular table icon. It's basically reverting all the changes. It's not happening to everybody in the team, just me.

If I edit instead of load(as shown in the 2nd pic) the icon looks like the measures (as shown in the 1st pic) and then if I refresh it's behaving as shown in the 3rd pic. I uninstalled powerbi, deleted the folder and reinstalled, but still having the same issue. Has anybody faced this kind of issue? Or know the solution to fix this?

hhebbalu_0-1626801255163.pnghhebbalu_1-1626801454843.pnghhebbalu_2-1626802034708.png

 

 

Thanks

7 REPLIES 7
hhebbalu
Frequent Visitor

@mwegener @v-shex-msft  I added screenshots and edited the post. Please let me know if I make sense now.

Hi @hhebbalu ,

 

can you show if anything has changed in the column structure of the tables?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Hi @mwegener ,

 

Not sure if this is what you mean when you say column structures in table being changed. After the refresh when I compare the new pbit with the old pbit(prior refresh) in ALM toolkit, I can see below changes. The columns are visible whereas they were hidden before. Please look at the screenshot below, for eg; the AccountSubaccountKey was hidden but it's now visible. and many other columns and even the formats are gone. Along with the previous icon issue that I mentioned.

hhebbalu_0-1626904915172.png

 

Hi @hhebbalu ,

 

cool that you are already familiar with the ALM toolkit.
That's exactly what I wanted to check. In this example, the AccountSubaccountKey column has the same GUID for the "lineageTag" column, so I assume that it really is the same column and not a column that was recreated after the data load.
Have you already tried the new Power BI Desktop release?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


That is right. It's reverting the visibility or formats in some(most) existing columns when I refresh in the desktop. It's also doing that icon change for the measures table. This is not happening to others in the team. 

And yes, I uninstalled the PowerBI and downloaded the latest version and installed it. No luck. 

v-shex-msft
Community Support
Community Support

Hi @hhebbalu,

Can you please share more detailed information with a pbix file to test? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
mwegener
Super User
Super User

Hi @hhebbalu ,

 

can you share more information about the source and maybe some screenshot about the queries?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.