Forum Discussion

webportal's avatar
webportal
Impactful Individual
4 years ago
Solved

Power bi dataflow Sign in canceled. (Session ID:

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 ...
Need Help
  • webportal's avatar
    webportal
    4 years ago

    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.

collinq's avatar
collinq
Super User
4 years ago

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's avatar
webportal
Impactful Individual
4 years ago

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's avatar
    v-easonf-msft
    Community Support
    4 years ago

    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