On-Premise Gateway refresh Column not found in rowset

[NielsDecoene]

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

[v-ljerr-msft]

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?

Regards

[NielsDecoene]

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.