cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
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 Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,950)