topic Re: error "Facebook: (#803) in Power Query

error "Facebook: (#803)

CABIRDUK — Tue, 11 Oct 2016 14:19:29 GMT

Tutorial: Facebook analytics using Power BI Desktop

All is OK until one tries to sign in to Facebook.

Use "me" and then for example select Friends and a blank graph is returned. Use a username or Object ID and the error below appears.

Details: "Facebook: (#803) Cannot query users by their username (ChristopherAlexanderBird)"

Tutorial applies a company page is it not possible to analysis a personal page?

Thank you.

Re: error "Facebook: (#803)

CABIRDUK — Tue, 11 Oct 2016 14:37:55 GMT

I acknowledge Tutorial: Facebook analytics using Power BI Desktop applies to Facebook company page and not personal pages.

If I use username or object ID I get an error returned.

Details: "Facebook: (#803) Cannot query users by their username

Internet search for a solution for example Stack Over Flow Facebook - “Cannot query users by their username” solution suggests you cannot query usernames.

Is there solution? I suspect not.

Thank you.

Re: error "Facebook: (#803)

v-qiuyu-msft — Wed, 12 Oct 2016 06:09:44 GMT

Hi CABIRDUK,

The Facebook connector in Power BI Desktop relies on the Facebook Graph API. The /me node is a special endpoint that translates to the user_id of the person (or the page_id of the Facebook Page) whose access token is currently being used to make the API calls. For more information, please refer to Facebook Graph API.

In your scenario, please use Me instead of the username to retrieve data. For more information, please refer to this similar thread: Facebook - “Cannot query users by their username” solution.

Best Regards,
Qiuyun Yu

Re: error "Facebook: (#803)

CABIRDUK — Wed, 12 Oct 2016 10:02:29 GMT

Thank you for prompt reply. I really appreciate you taking the time to do so.

I would point out type "Me" and not "me" the query is case sensitive.

Have a fabulous day.

Best regards

Christopher

Re: error "Facebook: (#803)

CABIRDUK — Mon, 02 Apr 2018 09:53:06 GMT

Pandora Login has nothing to do with the issue.