Dataset not refreshing

[fernandosilvauk]

Hi there, this is the second time I'm posting about it and seems like no one is getting the same error than me, so I would like some help please if possible.

Since the update on Power Virtual Agents 05/23, my dataset from PVA is not able to refresh and is disabling automatic.

The following message is the error:

Data source error: Column 'botid' in Table 'bots' contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. (botid (181)). Table: bots.
Cluster URI: WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: be8e8af6-8ca6-9e35-a710-992563b10955
Request ID: 63047df3-5ca9-f5b5-29e2-3ac05d2bb2d8
Time: 2023-06-13 08:42:02Z

Unfortunately, this is not on our azure server and I believe it is a Microsoft Power Bi and Power Virtuyal Agent bug.

The table in question from the message above, shows bots that don't exist anymore and that is causing the dataset not to refresh.

Any idea how to sort that out or any Microsoft Engineer to look into it, that would be great.

Kind regards,

Fernando Silva

[mahenkj2]

hi @fernandosilvauk 

I am not sure, but is it possible to remove the dataset and publish it again?

Hope it helps.

[fernandosilvauk]

Thank you @lbendlin .

Our dataset has been without update since 25/05/23 and not a single response from Microsoft so far.

Let's see if opening a ticketing for Pro License works.

Finger crossed.

Thank you.

[lbendlin]

You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi