This is a repost from my own blog, with the reason being that some people only come to the Power BI community to look for solutions, and might miss this blog post which could assist them.
I was recently testing out the new awesome dataflows in Power BI, and no matter what I did my dataflow refresh would fail.
I was getting the same error no matter what I did.
In order to find the error details for my dataflow I did the following:
This is the error that I was getting.
I thought let me see if I can try out a few different scenarios to troubleshoot where the issue was coming from.
Now I was thinking, what is going on with my own Power BI tenant?
Was it something I did?
Was there some setting that I possibly changed?
I then reached out to the Power BI team and asked for assistance.
I must give a big shout out to Anton, Sagiv and Bat-chen from the dataflows team, they assisted me in troubleshooting the issue.
The reason it was failing is because on the account I was using I have got Multi-Factor Authentication (MFA) enabled.
This now makes total sense, because in the other Power BI tenant I was testing on, it was a standard account with no MFA enabled.
As you can see below in the muti-factor authentication settings my account has a status of Enforced
The wonderful people from the dataflows team advised as a short-term solution to use an account that does not have MFA
I tested this and it worked perfectly!
The people in the dataflows team, are fixing this problem but it will take some time.
Once I have an update from them and I can verify that it does indeed work, I will update this blog post.
I hope that you now know if you have an account with MFA and are currently using it for dataflows you could get some unknown errors.
And that there is both a short term and a long-term solution.
Any questions or comments please leave it in the section below!
Thanks for reading.
I just stumbled upon this issue today and this article was really helpful. Saved me a lot of frustration.
My current workaround is rebuilding all dataflows using a service account which does not have MFA enabled, but this comes at a price of hours and hours of work.
Perhaps Microsoft can keep us posted on the fix developments?
We are using power BI WEB part. It was working fine till now and suddenly started getting issues like
Data source error unable to get data from transport connection the connection closed.
We have written a web service and which is used in power BI web part.
Earlier getting issues related to ssl, after adding the certificate ssl issue was resolved.
Please help us what we can do for the same.
I had this exact same issue myself over the past week or so.
Turning MFA off, doing a manual and scheduled refresh, and then turning MFA back on again worked for me.
Hi @jcarville thanks for letting us know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.