Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I've got a custom hierachy - basic one, 2 text fields only - on a column chart. Works fine in desktop, but when published to service I get this:
Can anyone suggest a fix please?
Solved! Go to Solution.
Thank you for your help Adamk.
I'm not sure whether this was the issue; I looked at the data in service and it was recognising these columns, and I was able to build tables with them and they were behaving correctly.
Before deleting it, I re-published from desktop, and the visuals are working now, even when refreshed in service. Odd one - looks like it just didn't want to do any work on Friday. Don't blame it. Will give your solution a crack if the issue occurs again.
Hi @Caelan ,
There was a change to the underlying dataset, which is causing problems. The error message refers to a column named Office HierarchyFE Name, which is not in your data model screenshot.
You should go into powerbi.com and delete the dataset for this project and recreate/republish it.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help Adamk.
I'm not sure whether this was the issue; I looked at the data in service and it was recognising these columns, and I was able to build tables with them and they were behaving correctly.
Before deleting it, I re-published from desktop, and the visuals are working now, even when refreshed in service. Odd one - looks like it just didn't want to do any work on Friday. Don't blame it. Will give your solution a crack if the issue occurs again.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
20 | |
20 | |
19 |
User | Count |
---|---|
52 | |
51 | |
26 | |
26 | |
22 |