I can't see the data in Power BI, in the database - yes

[Karlie69]

Hope this post was posted in the appropriate section.

I have a query with several union all. In each subquery, I have a column called DATATYPE (Budget, Reserved, Invoiced).

One subquery is for budget (2015-2021). I added another union all because the budget for 2022 refers to a different view in the database (Oracle). And while in the database I see budget values for 2022, when I load this query into Power BI, I still only have values for 2015-2021 (of course, I refreshed the data more than once).

Does anyone have an idea why this is happening? 🙂 I can see data for 2015-2022 in the database without any problems.

[Karlie69]

No, unfortunately I have an empty table then

[bcdobbs · Accepted solution]

Ok, it's almost certainly something to do with the security on the SQL database. At a guess some SQL RLS is kicking in.

When you connect to the view directly in oracle sql are you using the same logins as power bi? 

[Karlie69]

The data doesn't even appear in Power Query.

I was also wondering about the date format, but in the other "union all" the format is the same and everything is displayed correctly in Power BI.

[bcdobbs]

Is data not showing in a visual or is it not appearing if you go directly and look at the table view?

Wondering if you have an issue with your date table.

[bcdobbs]

If you simplify it and just connect directly to the 2022 view do you get any data back?

[Karlie69]

Yes, I use the same. But you're right, it could have something to do with the 2022 view link. I'll check it out tomorrow at work.