Unable to connect to csv in sharepoint online

[David-Menacho]

I have a power bi that connects to a csv from other company, when i manually refresh its ok and i can see the recent data. The type of autentication is organizational and i can access with my credentials.

Problem is when i publish my report and try to set connections, no matter what autentication type i try when i test connection it throws an error, aditional there is no organizational autentication.

Can you help me how can i connect with these csv?

Regards

[Anonymous · Accepted solution]

Hi @David-Menacho ,

SharePoint Online datasource doesn't support schedule refresh, so you could not set the data source in PBIRS Web Portal.

For more details, you could read related document: Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BotCat]

I experience the same issue when connecting to an on-premise gateway for Oracle database. It refreshes on desktop app but once I publish it, it does not. My data model has merged tables. If I publish a report without merged tables from the same data source, it refreshes. So I'm guessing there is an issue with merging tables? Is there a solution to this?

UPDATE: My issue is coming from it being an Import query and not a directquery. Refresh works on merged tables when in DirectQuery mode. Why would this be?