Import Excel from Sharepoint option in PBI Service - Do I Have Any Formatting Options?

[riegersn]

Hi! I've imported an excel document as a dataset from my teams sharepoint site. Imort works great, however I want to format some of the data thats being shown. For example 0.98 -> 98% - I understand this is possible in the desktop version but without a gateway in place currently It doesn't seem possible to have it automatically refreshed any other way than importing it via the service.

[Greg_Deckler]

@riegersn - Right, so what you want to do is import that Excel spreadsheet into Desktop. Create your report and format it. Then you Publish it to the Service. Once it is published, then you setup automatic refresh.

[GilbertQ]

Hi there

What I would suggest doing is to create it in Power BI Desktop, which will allow you to create and format the measures as you need.

Then upload this to the PBI Service. And then use the Teams Power BI App to connect to the report?