Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Artjom_Zelenjuk
Frequent Visitor

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. 

Artjom_Zelenjuk_0-1692629281560.png

 


How can we troubleshoot further? any advice?

 

Thank you and Best Regards 

Artjom

5 REPLIES 5
sergej_og
Post Prodigy
Post Prodigy

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

Regards
Sergej

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

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

Hello Sergej,

 

i tested again with new csv file and as well with the related. 

Connection via web as well via Sharepoint works fine. 

I Can't reproduce the error with a new PBIX File.


A Redesign of the report should fix the Bugs. 

 

Best Regards 

Artjom

aj1973
Community Champion
Community Champion

Hi @Artjom_Zelenjuk 

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors