cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karlie69
Regular Visitor

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

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.

1 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? 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

6 REPLIES 6
Karlie69
Regular Visitor

No, unfortunately I have an empty table then

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? 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Karlie69
Regular Visitor

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
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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

 

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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.

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors
Top Kudoed Authors