Forum Discussion
Modifying JIRA content Pack
Hi miguel,
I'm trying to find out why my query doesn't refreshs on the cloud, that's right.
In my local, the pbix file refresh whitout any problem but when I uploaded to the online service didn't work.
I don't have any query with the name "AutoRemovedColumns 1", in fact, I have been looking for information about and It looks like It's a generic name that shows always in this kind of error. I have seen many people's screenshots with this error that says that it doesn't have any query with the name "AutoRemovedColumns 1".
I only have 1 query that references to 4 functions and 1 parameter. That could be the problem?
PS: Thanks for the advice, the trace It's deleted.
depending on how those 4 functions interact with that query, that could be the problem. If it's doing another reference, or trying to combine data sources, then it might give you errors on the Power BI service.
Power BI Desktop and the Power BI have disparity. Some things might work nicely on the Dekstop, but not on the cloud and its usually due to Privacy Levels that provoke the Formula.Firewall.
There's no simple solution to this. You'd need to deconstruct your query and start testing by pieces to see if it refreshes on the cloud. My suggestion is to start with your initial query, upload it to the service and see if it refreshes. Then add 1 new function to that query and see if it refreshes on the cloud. Keep doing that last part until you hit the error and you'll find what function is the culprit of the problem