cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NielsDecoene
Helper I
Helper I

On-Premise Gateway refresh Column not found in rowset

Hey,

 

In my Power BI environment, I have an On-Premise Gateway setup for my report.

This report connects to:

-SQL Database A
-SQL Database B

-(has a table entered with Enter Data)

 

I have published this report to Power BI online and I have scheduled the refresh.

However on refreshing the dataset i get the following ERROR:

Data source errorThe 'Age Min' column does not exist in the rowset

 

This is a column in my 'Enter Data' Table, which in my Query Editor has not been included in the report refresh.

I have tried renaming/republishing/rescheduling but to no avail.

Any hints on how to set this right in Power BI?

--In Power BI Desktop the refresh goes fine.

 

Regards

2 REPLIES 2
v-ljerr-msft
Microsoft
Microsoft

Hi @NielsDecoene,

 

According to your description, I just verified that the schedule refresh works all fine with a similar dataset on my side(tables from SQL Database and table entered with Enter Data) via On-Premise Gateway.

 

Have you tried removing the entire dataset from Power BI Service first, then republish the pbix file to see if it works?Smiley Happy

 

Regards

So I cleared my Power BI online datasert/reports/dashboards

 

I Start Power BI Desktop:

-Publish to (my dev team workspace)

-Datasets -> Apply the on-premise gateway

-Check my Gateway's Data Sources and both SQL sources are working just fine

 

Same Error:

Data source errorThe 'Age Min' column does not exist in the rowset.
Cluster URIWABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity IDafc99178-7a61-411c-8f51-86cd10c5deb6
Request ID578bd235-1f34-a37a-e120-016b017c88da
Time2017-01-27 08:39:38Z
 
To check whether my Gateway is working, I've tested it on another project with just a SQL server connection and the refresh works fine.
 
There is Dynamic RLS in the project.
Gateway data source connection is basic with sufficient rights:
-The column on which it errors is used, in a calculated column that uses cases.
 
If there are is any other information I can supply you with ask ahead.
 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors