Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Marcinvelcino
Frequent Visitor

Large dataset refresh issue, changed column name

Hi,

 

I have a large (around 9.5 gb) dataset published to Power BI service. I got an error when tried to refresh : The 'ColumnA' column does not exist in the rowset. I checked and currently in source (sql serwer) the column name is ColumnB. 

The problem is that I don't have currently access to pbix file on my desktop to refresh it and re-publish and for this size I am also not able to download file from service. 

 

I tried and XMLA endpoint connection (the Workspace is premium) using tabular editor and change column name to ColumnB. It worked and I see the new column name in model, but the refresh issue remains. 

 

There are no others steps is Power Query for this table, only those defualt after load without transformation. 

1 ACCEPTED SOLUTION
Marcinvelcino
Frequent Visitor

I managed to fix the issue by editing "Source column" property in tabular editor connecting to XMLA endpoint.  After I set a proper column name the refresh went fine. 

View solution in original post

3 REPLIES 3
Marcinvelcino
Frequent Visitor

I managed to fix the issue by editing "Source column" property in tabular editor connecting to XMLA endpoint.  After I set a proper column name the refresh went fine. 

Thank you so much! Been trying to find a solution for this for a couple of days now.

123abc
Community Champion
Community Champion

Changing column names in Power BI datasets, especially for large datasets, can be tricky, especially if the changes are not synchronized with the source. It seems that you've encountered an issue where the column name in Power BI doesn't match the source, and you're unable to refresh the dataset due to the size constraints. Here are some steps to help address this issue:

1. **Power Query Editor (Power BI Desktop)**:
- If you can gain access to the Power BI Desktop file (PBIX), you should open it and use the Power Query Editor to change the column name directly within Power BI Desktop. This is the most straightforward and recommended approach.

2. **Direct Source Access**:
- If you have access to the SQL Server and can change the column name back to 'ColumnA' to match what's in the Power BI dataset, that would be the ideal solution. Once the source matches the dataset, you should be able to refresh it without errors.

3. **XMLA Endpoint (Tabular Editor)**:
- Since you've already tried using Tabular Editor to change the column name to 'ColumnB,' here are some additional steps you can follow:
- Save your changes in Tabular Editor.
- Go to the Power BI Service.
- In the dataset settings in the Power BI Service, check if you have the "Allow schema modification" setting enabled. This setting allows schema changes like column renaming.
- Trigger a dataset refresh from the Power BI Service. This should apply the schema changes from Tabular Editor.
- After the refresh, you can then go back to the source and change the column name to 'ColumnA.'
- Finally, refresh the dataset again to ensure it matches the source.

4. **Recreate Dataset (Last Resort)**:
- If none of the above steps work, you might have to consider recreating the dataset from scratch in Power BI Desktop with the correct column names and then republishing it to the Power BI Service. This should be a last resort due to the large dataset size.

5. **Contact Support**:
- If you've exhausted all options and still can't resolve the issue, consider contacting Power BI support. They may be able to provide specific guidance or assistance for your situation.

Please exercise caution when making schema changes in a production dataset, especially if it's a large dataset. Always ensure you have proper backups and a clear plan for recovery in case anything goes wrong during the process.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors