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 something?

 

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

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.

6 Replies

  • webportal's avatar
    webportal
    Impactful Individual
    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

    Hi webportal ,

     

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

  • webportal's avatar
    webportal
    Impactful Individual
    4 years ago

    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'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.