Including a user-defined table in a report

[dougp]

Is the only way for a user to include a table in a report to upload a spreadsheet and combine it with [whatever] in a data module?

Power BI provides the user the ability to define a table.  That's what I'm looking for.

[MFGF]

Is the only way for a user to include a table in a report to upload a spreadsheet and combine it with [whatever] in a data module?

Power BI provides the user the ability to define a table.  That's what I'm looking for.

I have seen reports in the past (I think it was back in Cognos 10) where the author added manually coded SQL using literal values to emulate a table, then joined this within the report to other data. Is this the sort of thing you're looking for Doug?

Cheers!

MF.

[dougp]

Nope.  This would be for my users.  No SQL.  You can't require people who analyze data to know a data language.  :P   I'll get them to use data modules and Excel files.

[MFGF]

Nope.  This would be for my users.  No SQL.  You can't require people who analyze data to know a data language.  :P   I'll get them to use data modules and Excel files.

Yep - it could be quite dangerous too giving regular users access to SQL :)

Sounds like Data Modules and uploaded files are the way to go. Good luck!

MF.