Forum Discussion
Solved
Table: Number/Names/Order of columns changes over time
Hi all! I'm moving a table from an Excel deliverable to a Power BI deliverable. The table is a Direct Query link to a SQL view. Trick is, the view has 400+ columns that can vary depending on the prod...
Hi SokMunki ,
According to your statement, I know that you use Direct Query connection mode to get data. As far as I know, Power BI will load all metadata from your data source into data model. Metadata contains all data about columns in your data source. I think you can see all columns in Power BI.
For reference:
Using DirectQuery in Power BI - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry about the lack of borders between cells in the HTML tables up there, by the way. Can't seem to get that to work.