Forum Discussion
Problem displaying some columns in Power Query (from Power BI Desktop)
Hello,
I'm beginner with Power BI. I have loaded some tables from a MySQL database.
In Power BI desktop (Model or Data views), I can see the different columns/attributes that I expect to see.
When I open Power Query ("Transform Data" from Power BI desktop), I don't see all the columns. I can't find/display them. They are also not visible via the "Reach Column" feature.
Could you please help me?
Sorry if the answer is obvious!
Thanks in advance
Davou
6 Replies
Hello,
I'm beginner with Power BI. I have loaded some tables from a MySQL database.
In Power BI desktop (Model or Data views), I can see the different columns/attributes that I expect to see.
When I open Power Query ("Transform Data" from Power BI desktop), I don't see all the columns. I can't find/display them. They are also not visible via the "Reach Column" feature.
Could you please help me?
Sorry if the answer is obvious!
Thanks in advanceHi davou,
The columns that you create in DAX, that is the Data tab in Power BI Desktop, won't be visible in Power Query. It is possible to all columns from Power Query in DAX but not the other way around.
Mark this post as a solution if that works for you!
Check out this post of mine: Forecast Period - Previous Forecasts
Spare some time to read: How to Export Telemetry Data from Azure IoT Central into Power BIHello, the same thing is happening to me, I wanted to ask if you managed to correct the problem.
Hi davou
Are these columns existing in the data source? If these columns are calculated columns created with DAX, they are in the data model layer. They cannot be seen when you open Power Query Editor as Power Query Editor is used to load and transform data. This happens earlier than data modeling.
In addition, what is the "Reach Column" feature? I'm not impressed with this feature. Where did you see it?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
