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?
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.
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?
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.
Can you please share more detailed information with a pbix file to test? It should help us clarify your scenario and test to troubleshoot.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.