Forum Discussion
New bug: The column does not exist in the rowset.
Hi, recently I've started getting an error in Power BI Service, which does not happen in Power BI Desktop
I'm getting "column does not exist in the rowset" error when refreshing a published dataset in which column names were changed. Column names are not referenced anywhere in the query or DAX formulas.
Repro steps:
1. Publish a Power BI Report that translates datasource columns to Power BI data model table columns as is (make sure no column name is explicitly referenced anywhere). For example: SharePoint List (see the full code listing below);
2. Rename a column in the source dataset
3. Try refreshing the published dataset. It would fail in Service, but not in Desktop
let
Source = SharePoint.Tables("https://<...>.sharepoint.com/", [ApiVersion = 15]),
#"18b84cec-73a7-4841-9c09-c14b4ee402e2" = Source{[Id="18b84cec-73a7-4841-9c09-c14b4ee402e2"]}[Items],
Custom1 = #"18b84cec-73a7-4841-9c09-c14b4ee402e2",
Custom2 = Custom1{0}[ContentType],
Custom3 = Custom2[Fields],
#"Removed Other Columns" = Table.SelectColumns(Custom3,{"Title"}),
#"Transposed Table" = Table.Transpose(#"Removed Other Columns"),
#"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true])
in
#"Promoted Headers"This wasn't the case until recently
Hi Burma ,
For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
14 Replies
- venalMemorable Member
Note:- Clear the cache from the Power BI Desktop >> File >> Options & Settings >> Options >>Data Cache, Q &A Cache (Clear Cache)
Open the PBIX file in Power BI Desktop.
Home >> Edit Queries >> Edit Queries >> Refresh Preview >> Refresh All >> Close and Apply
Home > Refresh >>Check for the data in all the visuals to all the pages in the report level.
File >> Save As >> with different name and publish.
Try to check with "Refresh Now/Schedule Refresh". (If it is required, try to configure the data source to the gateway).
If you get any error, please share the error information from the "Refresh History" by clicking on "Show Details".
- BurmaHelper I
Tried that already, no change...
- v-lid-msftCommunity Support
Hi Burma ,
For the issue, I cannot reproduce it here. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- PowerQA1Frequent Visitor
Clearing the cache just as listed her resolved this issue for me.
Thank You!
- jnixonAdvocate II
I had same problem this morning. Cleared caches, didn't help. In the end, I found that the columns in question had a (lf) in the name. When I renamed the columns without the linefeed, everything worked. Not sure if this is your problem, but wanted to share my solution.
- GregoryDFFrequent Visitor
Thanks!
I had the same error, and it was indeed caused by a linefeed in the name of the column...
- csabilAdvocate II
Any update on this issue?
It started happening to me yesterday after updating on of the source files (excel on SharePoint). It's looking for "Column70" which doesn't exist and not referenced anywhere in the query either.
When you say you solved removing the lf from the column name, which column? It's looking for one which doesn't exist...
Thanks for the help
- BurmaHelper I
It also refreshes fine in the desktop app but fails in the web app?
The original issue seems to happen with SharePoint lists, but not Excel files