Forum Discussion
Added column not found after publishing
Hi,
In my desktop file, I have added hour column from datetime and filtered it for specific time (6 AM to 6 PM) in the power query. I can see the added column in data view and this way I can show only the filtered values on the visual for 6 AM to 6 PM on power bi desktop.
After doing this change in my desktop file, I have published the report and replaced the existing dataset. This hour column in not showing up on power bi service file and the values are coming for the entire time 24 hours on the visual.
I have downloaded the .pbix file from the service and not found the added column in data view but it is there when checking in power query.
I am confused why is this happening and how to resolve this. Please suggest the way to overcome the issue.
Thanks
jitpbi I'm guessing some kind of cacheing issue on the Service is going haywire. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
4 Replies
jitpbi Well, if you added it in the data view in Desktop then that is outside of Power Query so explains why it does not show up in Power Query?
As for the other, maybe a cacheing issue? Is this published to an App and you need to republish the app? How do you know the column is not there? Are you going to the dataset like creating a new report and looking at the data model and the column is not there?
Hi Greg_Deckler ,
No I have not added it in the data view. I have added it in the power query and can see the added column in the data view.
Also, I have not published to any app. The report was already published before adding this column, so i simply republished the report and replace with the existing dataset. I can check for the column in the edit report and also after downloading the .pbix file that this column is not there at data view.
One more point, If i do publish the report after renamig it or publishing it to other workspace then this added column is there and the visual shows the filter values only.
Thanks
jitpbi I'm guessing some kind of cacheing issue on the Service is going haywire. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
