Using Excel as a data source in Business Intelligent Publisher

Question

HI,

We are trying to build a data model in Business Intelligent Publisher using a query and an excel spreadsheet. The query and and spreadsheet joined by an id. However, when we obtain data, the data coming from the spreadsheet are incorrect. Can you please help us? Please let me know if you need the screenshots, query or the spreadsheet. Thanks.

Thomas Dodds · Answer

You've got different data types between your keys TAB_ID and TABID ...

JCD-user · Answer

Hi,

The data model is showing the same Impression ID for all furniture furniture. We are expecting to see specific impression ID for each furniture. Please see the attached screenshots.

Gianni Ceresa · Answer

JCD-user wrote:when we obtain data, the data coming from the spreadsheet are incorrect.

How can you say it's incorrect? Publisher does what you tell it to do.

So maybe you can double check how you configured your sources and the join and make sure what you got is actually the right data.