SJK
Reputation: 1
Missing data fields from tables in Power BI
I am Using PowerBI Desktop Direct Query on SQL database
When the data is loaded into PowerBI Desktop I can see that there are certain fields missing from the table. When I view in SQL Server Manager Studio I can see the entire table.
Is there a known reason why all fields in the table would not be returned?
Upvotes: 0
Views: 4816
Answers (1)
Mike Honey
Reputation: 15027
Check in the Query Editor window (hit Edit Queries) - steps can be added to any Query to remove columns, or specify a selected set of columns.
It could also be that the columns were added to the SQL table after the Power BI Query was built. For that scenario you just need to use Refresh Preview in the Query Editor window and they will flow through to the Power BI table.
Upvotes: 1
Related Questions
- Why does Power BI table shows ''This table is empty" when data are loaded from a SharePoint list?
- PowerBI get data why doesn't get correct table?
- How to display missing dates in the data table Power BI
- Dynamic table data visible in query editor but blank in data view
- Why isn't column data for a table visible when viewing data?
- Power BI - The column 'Column1' of the table wasn't found error
- PowerBI table does not show value when using "Direct query" table
- Power BI dataset relationships grayed out
- Power Query to load Web data but no table shows
- How to handle missing fields in a PowerBI custom data connector?