Power bi dataflow Sign in canceled. (Session ID:

[webportal]

I keep gettin the errror:

Sign in canceled. (Session ID: xxx)

When trying to create a dataflow linked to a simple csv file in SharePoint.

Can anyone help? Are there any magical tricks or something?

Tried different browswers, log out/in , etc. nothing works!

[webportal · Accepted solution]

By having two datasources, I must pass them both through the gateway, even if SharePoint doesn't need one.

Otherwise, I get this error. It would have been so easier to solve, if the message of the error was correct.

[webportal]

Hi @collinq 

It is in the data flow.

It contains two data sources: a sql server connected through a data gateway and a CSV file stored in sharepoint.

[collinq]

Hey @webportal ,

So, you are in the data flow and have selected "Add new tables" and then you select the data source (SQL in this case) and then are getting a sign in error on the connection credential page?

[webportal]

Actually, it is the other way around:

I login to SQL and import the tables without any issue.

Then I'm asked a MS account login when trying to connect to the CSV in SharePoint - and I get stuck here.

[v-easonf-msft]

Hi, @webportal 
Related thread:

Unable to connect to Sharepoint folder "sign in canceled" 

By default, Google Chrome blocks pop-ups from automatically showing up on your screen. When a pop-up is blocked, the address bar will be marked Pop-up blocked  .
You can also decide to allow pop-ups.

Try to Change your default pop-ups & redirects settings.

1. On your computer, open Chrome Chrome.
2. At the top right, click More : > Settings.
3. Click Privacy and security > Site Settings.
4. Click Pop-ups and redirects.
5. Choose the option you want as your default setting. 

Best Regards,
Community Support Team _ Eason

[collinq]

Hi @webportal ,

Can you please clarify where you are getting this message?  Is it in Desktop?  The Service?  A specific Data flow?