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.
Quote from: dougp on 28 Oct 2020 01:49:06 PM
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.
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.
Quote from: dougp on 28 Oct 2020 06:16:34 PM
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.