Forum Discussion
Two power bi tabs getting data from two different table without having any any relationship
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.
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.