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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

"Column does not exist in the rowset"

Hi There,

 

I was trying to refresh my report on pbi service and i am getting below error again and again

"column does not exist in the rowset".

I have tried refreshing my desktop file which is getting refreshed and i am not getting any error there.

I also checked my data source and niether i have deleted any column/rows nor i have re-named any column/rows.

 

For better understanding , please see the attached screenshot.Capture.JPG

Can anyone please suggest what will be the solution for this?

 

Thanks,

Ashish Kumar 

1 ACCEPTED SOLUTION

Please revalidate that you are using same server, database, table/view and with same credentails in both places

If yes, I would recommand to raise support request Support | Microsoft Power BI


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

8 REPLIES 8
v-yetao1-msft
Community Support
Community Support

Hi @Anonymous 

Sometimes this error is because a column was moved, renamed or removed in the original data source.

You can clear the cache from the Power BI Desktop >> File >> Options & Settings >> Options >>Data Cache, Q &A Cache (Clear Cache) ,then go back to desktop and save a renamed version of the report and publish that and see if the renamed version works.

 

Best Regard

Community Support Team _ Ailsa Tao

v-yetao1-msft
Community Support
Community Support

Hi @Anonymous 

First , if you want to refresh your report in Service, you need install and configure gateway . If you just work with the report by yourself and the datasource connection is Import mode , you can install personal gateway .If you create report and share with other users , you need to install standard gateway . The links below can help you to configure gateway and then refresh your report in Service .

Install and configure gateway

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-app

Configure datasource in Manage gateways in Service

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

Configure scheduled refresh in Service

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

 

Best Regard

Community Support Team _ Ailsa Tao

Anonymous
Not applicable

Hi @Alisa-msft,

I am aware about gateway and this report i was using from last 6 months and suddenly i recevied this error and my report is not getting refreshed on PBI Service.

I checked there was an gateway update and i have updated my gateway but still it's not getting refrehsed.

Not sure what is the reason behind this.

 

Regards,

Ashish Kumar 

arvindsingh802
Community Champion
Community Champion

It seems the account used to register the datasource in gateway does not have access to the desisred table/view

Please get same access level what you are using in your desktop and this will be resolved


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
Anonymous
Not applicable

Hi @arvindsingh802 ,

 

I am not able to understand exactly.

I have published the same report from desktop from my licence and in pbi service i am the admin of this report and i am logged in with my login only, so i am not sure where i should i look into.

 

 

I am asuming you are using a gateway to refresh your report
If yes - The datasource registered with a different account that does not have same access as your account have


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!
Anonymous
Not applicable

Hi @arvindsingh802 

Yes i am using gaetway to refresh my reports and i have used the same account from which i have created the report and still it's not giving me this RowSet error 😞

Please revalidate that you are using same server, database, table/view and with same credentails in both places

If yes, I would recommand to raise support request Support | Microsoft Power BI


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors