Report refresh fine on Power BI desktop but shows credential error during Power BI Online refresh

[sahilhira162]

Hi,

I have created a report which is picking up data from Wrike and Sharepoint. Since I added the sharepoint query, my report is acting bit wierd. I am able to refresh it on Power BI desktop and it doesn't shows me any credential error where as when I publish that report in Power BI web, it shows credential errors. And both the gateway setting and data source credential settings are inactive on dataset settings. PFA screenshot, Kindly help regarding the same.

Regards,

Sahil

[Anonymous]

Hi @sahilhira162 

If you're looking for an easier way of getting your Wrike data into Power BI, check this out: https://www.synchub.io/wrike-to-powerbi-connector

Simple platform that does the syncing for you.

– Bryce

[v-yulgu-msft]

Hi @sahilhira162,

Did you connect to multiple different data sources in a single report? If so, did you configure gateway for each of them?

Regards,

Yuliana Gu