Forum Discussion
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!
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.
NathanielBelow is one page with one table from one source.
6 Replies
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.
NathanielThanks, Nathan! I really appreciate. Do the tables need to be connected in the model view, or they can stand alone without being connected?
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
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?
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.
NathanielBelow is one page with one table from one source.
Perfect! thanks for all the help! I really appreciate!
