Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

vckbx

Dataset refresh error in Service when using Dataflows connector

Submitted by Helper I on ‎08-21-2023 12:47 PM

I've been beating my head against the wall on this one today.

 

I added a new dataflow table into a dataset using the Dataflows connector in PowerBI desktop. Everything refreshes fine in Desktop, but when I publish to the Service I get a "key didn't match any rows in table" error. I tried a lot of different things, and eventually re-created the table using the "PowerBI Dataflows (legacy)" connector. After publishing to the service, the dataset refreshes as expected.

 

Is there a known issue? The only related thing I see on the forums is actually the opposite... Users having issues with the legacy connector.

Status: Needs Info
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎08-21-2023 11:46 PM

Hi @vckbx 

So in your environment "PowerBI Dataflows (legacy)" works fine, but there is a problem with the Dataflows connector,right ? May I ask what version of PBI Desktop you have? Were you able to use the Dataflows connector properly before? Or is this your first time using it ?

 

Best Regards,
Community Support Team _ Ailsa Tao

vckbx
Helper I
Helper I
‎08-22-2023 05:18 AM

PBI Desktop version 2.120.731.0 64-bit (August 2023)

 

Yes that is correct. I have never had any issues with the "Dataflows" connector and have been using it exclusively for the past 6 months or so. I have other datasets that use the "Dataflows" connector and are refreshing fine.

Idea Statuses