- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Two power bi tabs getting data from two different table without having any any relationship
Hi,
Just wondering if it is possible to create two different visuals in two different tabs in a single power bi file where each visuals are having different data source, like one data source from EXCEL and the other would be from ORACLE tables?
I really appreciate your help!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fhm_2022 ,
You will have two different sources of data, two different pages in your power bi report. The short answer is no these do not need to be connected in the data model. This is actually very simple to do. Set this up in your desktop, and then publish to the Power BI Service. You will need to set up two different gateways - one to each datasource, and then set your dataset to automatic refresh. The Service goes out to each data source and gets the refreshed data. It gets more complicated when you DO WANT the sources to be connected. I can reccommend Matt Allington's book Supercharge Power BI for around $30 on Amazon.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Below is one page with one table from one source.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perfect! thanks for all the help! I really appreciate!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, again.
So, for example, I will have sales data from Oracle for which i will have a tab as sales data and i will have my visuals for this data set. For the second tab, I will have quote data from excel files and i will have different visuals and metrices for this data set. So, to have this two tabs fully functional for two different data sources and to get those data refreshed automatically, do i need to connect these two different data tables in power bi?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fhm_2022 ,
You will have two different sources of data, two different pages in your power bi report. The short answer is no these do not need to be connected in the data model. This is actually very simple to do. Set this up in your desktop, and then publish to the Power BI Service. You will need to set up two different gateways - one to each datasource, and then set your dataset to automatic refresh. The Service goes out to each data source and gets the refreshed data. It gets more complicated when you DO WANT the sources to be connected. I can reccommend Matt Allington's book Supercharge Power BI for around $30 on Amazon.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Below is one page with one table from one source.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fhm_2022 ,
Yes it is possible to create two visuals from two different data sources in one power bi file. It is done all the time.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, Nathan! I really appreciate. Do the tables need to be connected in the model view, or they can stand alone without being connected?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @fhm_2022 ,
Please give me more details. If I understood your first post, my answer to this post is no they do not. I will post a sample pbix for you, but a little more info is needed.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-07-2024 02:17 PM | |||
03-18-2024 10:34 PM | |||
02-15-2024 07:01 AM | |||
03-04-2024 06:51 AM | |||
04-04-2024 06:46 AM |