This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
I am working with azure analysis services , the tabular grid view shows blank values but showing all values in the power query editor. I have vs 2019 community working with SQL Server 2019 and compatibility level 1500. The power query editor shows all values but the values in the grids are blank.
Hi @tayyabvohra , we have not get a reply from you. Did the answer could help you? If yes, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!
Hi @tayyabvohra , any update for this thread? Could you please do "Accept Answer" if below anwser helped you? By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!
Hi @tayyabvohra ,
Welcome to Microsoft Q&A!
When I create the measure grids as below, it also shows blank:
In the grid view, the measure calculates as the grand total of the model, without any filtering. The results as below when I give a condition to the measure in Pivot Table:
Please refer to this thread.
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
it shows blank values in the grid rather than in the measures. I am getting empty columns in the grid but not in the power query editor.
Hi @tayyabvohra , sorry for the misunderstanding. Have you reprocess cube and check the relationship? Please refer to this thread to get more information.