Forum Discussion
Power BI data not displaying in Report
I have read through a view similar Q&A's, but still cannot get my issue resolved. I import a large set of data from multiple clients from a SQL table. In the data view, the specific client data displays. When I change to report view and use the filter to select this client, it displays nothing. However, any other client that I select using the filter, displays. So it tells me the relationship is good. I have also refreshed each individual table manually. Any ideas?
I made a change to the filters and it looks like it worked. Thank you for all the replies.
7 Replies
- amitchandak
Super User
EstelleH ,is it happening on power bi service or desktop. Are you using RLS ?
Can you share some screenshot
On Desktop.
Data from the table for that specific client. Then I change to view the report:
- amitchandak
EstelleH , I see a lot of TOP measures used. and if the top is used with allselected and this customer do not fit because of some slicer or filter, then it might not come.
If you are using all, then it should come in the top 5 or 10 to appear in those visuals
I think this might be causing the problem:
For some reason the FILTER used on all pages, are grouping the records under BLANK and not the actual installation name. Again, the data does not have any BLANK installation names. Not in the SQL Table or the BI data set.
- v-janeyg-msft
Community Support
Hi, EstelleH
Are you sure these two fields are on the same table? Does the field have a relationship? We need to more details to judge.
Best Regards,Community Support Team _ JaneyI made a change to the filters and it looks like it worked. Thank you for all the replies.
