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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Data Source error: Column not found in rowset

Hi 

 

I have connected sharepoint file as one of the data sources to my pbix file. The file is expected to have dynamic columns. I'm using parameterization to bring those dynamic columns into my table visuals on the report. Report refresh works fine in desktop app and was working fine in power bi service until the April release. Refresh fails with this error in service:

  • Data source errorThe 'xxxx' column does not exist in the rowset. Table: A.

Could I please report this as a bug, thanks

 

 

Status: Investigating

Hi @brus4814 ,

 

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

 

Best regards.
Community Support Team_Caitlyn

Comments
v-xiaoyan-msft
Community Support
Status changed to: Investigating

Hi @brus4814 ,

 

Can you provide detailed version information so we can reproduce the issue? We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

 

Best regards.
Community Support Team_Caitlyn

brus4814
Regular Visitor

Hi

I'm using the PBI version released on April 15. Thanks

brus4814
Regular Visitor

Hi, 

 

Do you have any update on this one? Thanks very much!

brus4814
Regular Visitor

Hi @v-xiaoyan-msft 

 

I believe I've just found the potential issue causing this refresh error, at least in desktop. I'm not entirely sure if this is the case in PBI service. The refresh preview doesn't seem to be automatically refreshing when the source file is changed. When I close & apply, if the preview is not refreshed, it seems to load the columns available in the preview and not the updated file.

brus4814_0-1715741197636.png

I hope this helps with the investigating the issue further. Kindly let me know of any progress you have made on your end. Thank you!