cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SNPPowerbi Frequent Visitor
Frequent Visitor

desktop

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.

 

 

2 REPLIES 2
Highlighted
Microsoft dkay84_PowerBI
Microsoft

Re: desktop

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 Frequent Visitor
Frequent Visitor

Re: desktop

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)