topic Re: User seeing missing data for direct query report on Power BI Services in Report Server

User seeing missing data for direct query report on Power BI Services

Anonymous — Mon, 11 Jul 2022 21:14:56 GMT

I have developed a direct query (live, near real time) report. Users have been using it for a while, but lately a couple of users addressed the report they see has missing data comparing with other people's.

I see report working fine both on desktop and services, no missing data.

Any idea?

Re: User seeing missing data for direct query report on Power BI Services

v-luwang-msft — Thu, 14 Jul 2022 08:19:09 GMT

Hi Anonymous ，

Please check if you have configured RLS. Also try to republish the report and clear the user's permissions in workspace and re-grant the corresponding report permissions. Also it could be a network issue for those users, have them try using another test account with permissions and access on their computer to see if data will be missing, as well as using their account to test access on another computer with no issues.

Refer:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

Re: User seeing missing data for direct query report on Power BI Services

v-luwang-msft — Thu, 21 Jul 2022 07:40:07 GMT

Hi Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien