Import an excel table as a measures table into power bi

[josepcervello]

Hi Community,

Is there a way to import an excel table as a measures table into Power BI?

Thank you

[v-cherch-msft]

Hi @josepcervello 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here.

Regards,

[v-cherch-msft · Accepted solution]

Hi @josepcervello 

You may import data model from excel in desktop or service.Reference:

https://docs.microsoft.com/en-us/power-bi/desktop-import-excel-workbooks

https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

If you want to create a measure table,you may follow the steps in below article.

https://www.biinsight.com/define-measure-table-power-bi-desktop/

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards,