Importing Data - Pivot Tables Not Showing as Available fields

[weda9001]

Hi,

I am importing data from an excel into the PowerBI app (browser version) - however, the pivot tables that I have in my excel are not appearing as available fields in PowerBI.

I have tried manually formatting the pivot tables to Tables within the excel and refreshed, however, they are still not appearing.

Can anyone help?

Thanks,

David

[Anonymous]

Hi  @weda9001 ,

Please check the version of your Desktop, if it is not the latest version, please upgrad it to the latest one.

https://www.microsoft.com/en-us/download/details.aspx?id=45331

Then try to clear the previous credentials and reconnect.

1. In Power BI Desktop, Go to the File menu and select Options and Settings > Data Source settings

2. Clear the credential.

This is the related document, you can view this content:

https://community.powerbi.com/t5/Service/PowerBI-Data-Model-identity-field-not-showing-in-Excel-pivo...

https://community.powerbi.com/t5/Service/the-field-you-are-moving-cannot-be-placed-in-that-area-of-t...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[weda9001]

Hi

as per my original post, I am not using the desktop version of PowerBI. I am using the browser version (I am using MacOS).