The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to Solution.
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.
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.