I have a dropdown bounded to a SQL Server View (throuh Data Gateway).
The data consits of Text, Val (Year - Mounth, First date of month).
Everything is working great when i look at the app in preview mode, but when I publish it, the dropdown is showing empty rows (all rows are there, but with no text).
Go to Solution.
This type of behaviour can happen when 'Explicit Column Selection' is enabled.
Could you try turning it off from File > App Settings > Advanced Settings to see if it makes a difference?
View solution in original post
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand