Can't auto update or manual update a dataset

[david1sp]

I have 5 datasets, where 4 works correctly and I have one dataset where i can't update (automatic or manual) the dataset.

I can update it with "Refresh" in Power Bi Desktop but can't update in the app.

I tryed to delete the columns what i created in Power Bi Desktop, delete all dashboards but i didnt found the solution.

The dataset is a SQL Server and Oracle, with Direct Query, and i created the Gateway (it works good because i have 4 datasets more)

[v-yulgu-msft]

Hi @david1sp,

The dataset which failed to update contains two data source, SQL Server and Oracle, right? Did you add both two data sources to data Gateway? Also, please check whether the credential you specified when configuring gateway is correct. Besides, what error meesage was prompted?

Regards,

Yuliana Gu

[david1sp]

Both data sources are added in data Gateway.

The credential are okay because it works with others data sources.

Message error is: "There was a cancellation when sending or receiving an application"

I tryed to divide the data source in smallers data sources but it still doesn't work with a pair of smaller data source (same error)

[david1sp]

It's possible i can't update in Power Bi App because I have a column empty?

[david1sp]

Well, when i go to "Edit Queries" (Power Bi Desktop), i can see the column has the correct value, but in "Data" its empty

[david1sp · Accepted solution]

I deleted the column and it solved the problem