desktop

[SNPPowerbi]

Hi,

How to build powerbi report with dynamic columns from a table. Ex. - Table1 - 6 columns first build of report. next day Table1 - 10 columns. third day - Table1- 16. fourth day Table1 -4 columns.

So dynamically changing columns in table. how can we build report.

[dkay84_PowerBI]

This isn't really a valid question.  If you just connect PBI to a database or table and don't do any mashup of the data, then PBI will pull in all columns and rows.  If the column/row count changes, PBI will automatically pull in the content.

If you have done some ETL type transformations/mashups, you need to be aware of whether your queries are hard coding column names or index positions.  There are workarounds and best practices for those situations.  It has been heavily documented both on this forum and in blogs.  I suggest a web search...

[SNPPowerbi]

customer requirments are like this. When customer moves from one report technology to powerbi technology then look for more/less similar functionalities. Issues hasn't resolved so far.