Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply

Dataset not refreshing

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

 

3 REPLIES 3
mahenkj2
Solution Sage
Solution Sage

hi @fernandosilvauk 

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

 

Hope it helps.

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
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors