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
MichaelJ64
Frequent Visitor

Connecting to table in dataflow appears to prompt a manual refresh - is error message misleading?

Hi team,

I want to check my understanding of how dataflows work.  I have 3 dataflows - each creates a table from an Outloook mailbox (different mailboxes).  These dataflows are scheduled to update overnight.  I intend that the dataflows to have invariant tables throughout the work day and that I can fetch tables from them without needing to process the mailboxes.

 

Occasionally when running a program that connects to the dataflows I get the following error

 

DataSource.Error: ErrorItemNotFound: The specified object was not found in the store., The process failed to get the correct properties.
Details:
DataSourceKind=Exchange
DataSourcePath=air.tech@epa.nsw.gov.au
Details=

DataSourcePath here is a mailbox.  In this program I do not expect to be trying to connect to the mailbox, because the code fetches from the dataflow.  The relevant code for that is:

 

let

    Source = PowerBI.Dataflows(null),

    EnvSolAWNFGFolder  = Source{[workspaceId="3d42035b-fdcb-4bec-8b12-00133b61ffd2"]}[Data],

    AirFlows  = EnvSolAWNFGFolder {[dataflowId="9d17e3fb-874a-45a3-a947-3b99932beff8"]}[Data],

    AirIn1 = AirFlows{[entity="Air-NewIn"]}[Data],

 

I guess that the error listed above is in reality a form of time-out error.  But why does it point to the mailbox?  Have I been misdirected because the error message has the information of where the dataflow got its information?
If not, is there an ability to prompt a manual refresh of a dataflow.  If so, how do I turn it off?

 

I hope the question makes sense.  I expect it to be simple.  If this is a matter of local set-up, I apologise for posting to the Board and will get help from my host.

 

1 ACCEPTED SOLUTION
MichaelJ64
Frequent Visitor

Oh dear, this is embarrassing.

Just after posting I thought I should check that my claim that ALL my data sources were dataflows.  Nope.  They aren't.  One has snuck through that DOES fetch from the mailboxes.

I was hoping to delete my post but don't see how to.  

View solution in original post

1 REPLY 1
MichaelJ64
Frequent Visitor

Oh dear, this is embarrassing.

Just after posting I thought I should check that my claim that ALL my data sources were dataflows.  Nope.  They aren't.  One has snuck through that DOES fetch from the mailboxes.

I was hoping to delete my post but don't see how to.  

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
Top Kudoed Authors