topic Re: Adhoc reporting in Power BI in Report Server

Adhoc reporting in Power BI

KarthikCapz — Wed, 18 Apr 2018 13:21:34 GMT

Does Power BI support Adhoc Reporting? If yes how it will work? any reference link will be appraciatable

Thanks in Advance

Re: Adhoc reporting in Power BI

Anonymous — Thu, 19 Apr 2018 13:39:14 GMT

Hi KarthikCapz,

Power BI does support Adhoc Reporting and you can link to many data types such as CSV, SQL Server etc.

The link below talks you through how to set up a one off report:

https://www.youtube.com/watch?v=h6AIAxMEDiw

I hope this helps.

Re: Adhoc reporting in Power BI

KarthikCapz — Fri, 20 Apr 2018 13:34:03 GMT

Hi jdene,

The solution is good. But we have a different requirement.

My client will send any list of fields (adhoc) they require and we have to send the report. How it can be done?

Is there any way, once i copy those fields and paste it in a file, the listed fields should be generated as a report?

Re: Adhoc reporting in Power BI

Anonymous — Fri, 20 Apr 2018 13:50:35 GMT

Hi KarthikCapz.

Do you mean that you would like Power BI to automatically set up the charts for you without any intervention?

Re: Adhoc reporting in Power BI

KarthikCapz — Fri, 20 Apr 2018 13:52:14 GMT

Exactly. The fields will change dynamically.

Re: Adhoc reporting in Power BI

Anonymous — Fri, 20 Apr 2018 13:59:19 GMT

I don't think that is possible at the moment.

However a work around could be to set up some standard charts and amend the column names in from your CSV/Excel file to reflect the field names in Power BI.