Forum Discussion

bhenson's avatar
bhenson
Regular Visitor
4 years ago

Collecting cell format data into Power BI

Hello,   My team and I work with a bunch of client records that we update. In the spreadsheet that we track records with any fields that need to be changed in the metadata for a record are colored ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi bhenson,

In fact, power bi only gets the raw data to the power bi side. Normally they do not include any style and cell format information.

For this scenario, you need to also get the data from the table which stored the customize style or highlight information. Then you can use these information to check and remark original table records.

Regards,

Xiaoxin Sheng

bhenson's avatar
bhenson
Regular Visitor
3 years ago

How would one get that data? I've never done that before so I don't know how or have any idea for how to search that information on the web.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi bhenson,

    I think you need to contact the data source admin/provider to confirm where the source data of the sheet and corresponding table store the detailed style and settings.
    Then you can use the corresponding data connector or use a web connector to get data from Datasource or rest API.

    Regards,

    Xiaoxin Sheng