Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Filters don't work properly (or something else is broken)

Dear support,

 

I have faced a strange problem. I have a model in Power BI which includes several tables. The main 'parties' are groups of people who solve different tasks, and, on the other side, group of tasks themselves + translations for each group. According to our live database, we do have data for all the groups. But once it comes to PBI, I do see the data in tables, unless I go to Reports part. There, once I try to create a table with columns from other table, it works all fine for all user groups except one. Moreover, if I filter queries in Queries part to show me the data only for this user group, on Reports side it is not visible.

 

I though it might me something wrong with the way I created the data model, but it works all fine for all user groups except one! How is that possible? 

 

Then I thought, the data might be missing in tables. But when I open those in Tables part, I can see the data I need.

 

Do you maybe have any idea where to dig? 

 

Thank you in advance for your reply.

 

 

Kind regards,

T.

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous,

 

Would you please clarify for "once I try to create a table with columns from other table, it works all fine for all user groups except one. Moreover, if I filter queries in Queries part to show me the data only for this user group, on Reports side it is not visible."? 

 

Please share pbix file with us. You can upload it to your OneDrive or Dropbox, send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Needs Info
 
Anonymous
Not applicable

Hello @v-qiuyu-msft, I have shared everything with you in private messages.

v-qiuyu-msft
Community Support

Hi @Anonymous,

 

I replied to your private message. I'm not very clear about your issue, please share a video to show the issue if it's possible. 

 

Best Regards,
Qiuyun Yu