cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sh00un
Frequent Visitor

Oracle Dataset into Power BI

Hi everybody,

 

I have a situation where the Data Base admin created a Dataset to connect on my Power Bi Desktop, once I call the dataset, I noticed the middle icon is gone 

Sh00un_0-1632757892922.png

From now, I cant clean the data using DAX, I did try to change to Direct Query, then built a spreadsheet to try to call the "RELATED" function but I cant do anything, cant modeling the data.

Is there anything we are doing wrong? Please would help us a lot! Thanks

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@Sh00un table view is not available when using live connect to power bi dataset. you are not missing anything, this is how it works out of the box.

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
Sh00un
Frequent Visitor

Thank you @parry2k , deffinitely I wanted to hear that I was missing something but make sense.

Is there anything you would suggest to us as alternative solution?
Maybe a connection straight from the SQL server?

The main issue is, how can I see the data from the Data base server and modeling them and doing calculations and also refreshing my report only with a simple data refresh and all the data + calculations is updated and the dashboard is done?

parry2k
Super User
Super User

@Sh00un table view is not available when using live connect to power bi dataset. you are not missing anything, this is how it works out of the box.

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






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

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors