Forum Discussion
Dataflow Fails in Service, But Works in Editor—Issue with Specific Source at Merge
Hi Bof!
Thanks for replying. I took a look at the credentials and ensured they were correct and everything WAS set up fine. But I was hung up on you talking about credentials being specified in the service and so I kept looking for a credential spot OTHER than here:
And then I stumbled across this:
What even brought me here was weirder as far as I'm concerned:
- My FIRST issue w/ DataFlows was data coming from multiple sources and MS Support told me that that just wasn't permitted w/ pro licenses in a pro workspace (True or not I have no idea and don't care)
- Since then, I've been paranoid/adament that I'm just going to keep all data used in ONE source.
- When I clicked on "Manage connections" (To the left of "Options") I saw two sources there
- However... that's impossible. Because my dataflow is literally and definitely only looking at one SharePoint site and nothing else.
- But now I "knew" that the problem was being caused by multiple sources so then when I saw that checkbox in "Options" I thought "Well that clearly won't work"
But it worked. So, anyway, thank you for harping on credentials because in my investigation of that it became clear/obvious what the problem was with the dataflow.
Many cheers!
HI tnemeth ,
You might consider checking the following points:
1. Ensure that the credentials set in Power BI Service are correct. You could edit the data source credentials in the Power BI Service to confirm access to the data source.
2. Review the detailed error message to see if you can obtain more specific information to determine the issue.
Best Regards,
Bof
Hi Bof!
Thanks for replying. I took a look at the credentials and ensured they were correct and everything WAS set up fine. But I was hung up on you talking about credentials being specified in the service and so I kept looking for a credential spot OTHER than here:
And then I stumbled across this:
What even brought me here was weirder as far as I'm concerned:
- My FIRST issue w/ DataFlows was data coming from multiple sources and MS Support told me that that just wasn't permitted w/ pro licenses in a pro workspace (True or not I have no idea and don't care)
- Since then, I've been paranoid/adament that I'm just going to keep all data used in ONE source.
- When I clicked on "Manage connections" (To the left of "Options") I saw two sources there
- However... that's impossible. Because my dataflow is literally and definitely only looking at one SharePoint site and nothing else.
- But now I "knew" that the problem was being caused by multiple sources so then when I saw that checkbox in "Options" I thought "Well that clearly won't work"
But it worked. So, anyway, thank you for harping on credentials because in my investigation of that it became clear/obvious what the problem was with the dataflow.
Many cheers!
