Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Credentials Oauth2 not working with csv - Connection to Sharepoint not possible

Hello Community,

we work with an organizational Sharepointfolder as Datasource. Now there occurs a one of a kind Problem with on report. 

 

PBI Report contains 2 csv files (600MB & 700MB). Usually we integrate whole sharepointfolder and create references. 
In this case it wasnt possible (error unknown) and i set the Datasource as a web connection via Sharepoint.

 

Report functions ordinary in PBI Desktop. Publishing the report functions properly as well. But when i want to refresh the dataset (PBI Cloud), i get an error due to missing credentials. But i can´t set up the credentials for the dataset to Oauth2 (organizational) and get the following error. Neither are working other setups instead of Oauth - That´s how we usually create the connection. 

 


How can we troubleshoot further? any advice?

 

Thank you and Best Regards 

Artjom

5 Replies

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

    In Power BI Desktop you need to connect via Sharepoint Folder connector , not CSV connector

  • Hey Anonymous ,
    do you have a working connection established for this web connection?
    Not sure if i cathed your case right.

    Regards
    Sergej

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello Sergej,

      yes, the connection is established and is shown in PBI Desktop. The report shows also correct in the cloud despite we can#t refresh the dataset, because of the missing credentials.

       

      Regards, Artjom

      • sergej_og's avatar
        sergej_og
        Icon for Super User rankSuper User

        Hey Artjom,
        mhh, conncetion in Desktop is running, cool.
        What about the Gateway connection in Service? You have to create one in your gateway to access your datasource through Gateway.
        Is there a connection in Service for this web source?

        Regards,
        Sergej