Forum Discussion

SokMunki's avatar
SokMunki
Frequent Visitor
3 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.