Forum Discussion
Collecting cell format data into Power BI
Hi bhenson,
What type of data source are you working on? If you mean excel sheet, current power bi only gets the data, these additional styles and scripts on the worksheet will not be imported at the same time.
In addition, did these change operations apply to add new records to your tables or directly modify/replace the original records? If you mean the second one, current power bi not able to trace, it does not include any historical analysis features.
You need to back up these records to other data sources, then you can use powerbi to get data from both two data sources and compare.
Regards,
Xiaoxin Sheng
Hi Anonymous
For this client we are using Smartsheets instead of excel since both us and the customer can access the data without company constrant issues.
As for the new process the client wants us to duplicate the information that we have been marking in red into a new column. I am aware that PowerBI is unable to collect data changes, thus I want to use PowerBI to check that the information that we've marked in red has been included in the new column. The example below would result in PowerBI concluding that the Address is missing form the Meta-data updates column since the text is red but not included.
EX:
| Address | City | Project Number | Project Date | Meta-Data updates |
| 1234 w Main st | Candyland | ABC12356 | 1/1/2022 | change city to Candyland, change project date to 1/1/2022 |
The team is in the habbit of marking cells that they change information in to red, but not so much for filling in the new column. As best as we try we are human to where mistakes can be made so it would be nice to use PowerBI to help us check that we didn't miss anything.
As for getting a record of what things were changed when, only the client has access to run that report which we receive at the begining of the month for the previous month. We need something that we can use to check for issues ideally same day.
Please let me know if there is anyway to do this check in PowerBI.
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
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.
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