Forum Discussion
Rows showing null values when when import mode
Hi All, I have a Power BI report that connects to an Azure Analysis Services Model tabular model. There is one table causing an error. When connecting via direct query, All the values are import...
v-kkf-msft
Community Support
Community SupportHi afpbi ,
Chris Webb's blog mentions that the presence of nullable columns in SQL affects the queries PowerBI sends to the data source. Not sure if it applies to Azure AS as well, but you can try to verify using the ideas from this blog.
For more information, please refer to: https://blog.crossjoin.co.uk/2021/06/20/power-bi-power-query-and-nullable-columns/
Best Regards,
Winniz