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 imported correctly. But when I connect via import mode, there is one row which displays NULL values on all columns. I checked Azure Analysis Services for blank values and the source Synapse database but there''s none.
Tried to connecting to the AAS model using a blank report and can still see the null values. Left side is importing the table which is showing null values and right side is connecting to the whole mdel using live query .
All columns are null
No complex transformation was done to connect to the table - see below applied steps . The sorted rows step is only added to show the null value first
3 Replies
afpbi , That is strange. Hope there is no append step. Also, check there is no error while loading
Try adding steps to remove empty rows as a workaround.
Hi 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
