Web Source Credentials

[SQUILES]

Hi everyone:

I have a Excel file in my sharepoint that I use for my report. In PowerBI Desktop work fine, I configure like WEB, I paste the Sharepoint URL and ask me to sign in with my O365 account, and work fine. But when a Publish in PowerBI Service I get a error of Credentials aren't validated. What option I have to use Basic, Windows, Anonymous, I try all but still not refreshing.

Any suggestion?

[v-eachen-msft · Accepted solution]

Hi @SQUILES ,

You could use SharePoint folder to import your files.

Then login your microsoft account.

When you published it to service, you need to edit your credential like the following image.

You can try my solution and tell me if it works.