4 Replies Latest reply on Nov 13, 2018 2:13 PM by Andrés Salazar

    Feed Tableau with Power BI..... is it just a dream?

    Jimmy Nguyen

      Hi dear Tableau community...

       

      I have the feeling that Tableau requires clean database to work well. Unfortunately, it is not the case of my data :

           I have to load data from a folder with every week a new file (I need to agregate the files)

           My files are not clean and need to numerous transformation before

       

      It was heavy but I managed to do it with Power Bi.

      So now, I have a clean database in Power BI and I would like to use the visualization capabilities of Tableau.

       

      The question is : How can I feed Tableau with data in Power BI?

      The objective is to avoid to Open Power BI, extract the table, save it in a folder and Connect Tableau to this table.

       

      It would be great if we can connect the 2 Tools.... but I have the feeling that they just don't want to....

       

      thank you Tableau Community.

       

      Jimmy

        • 1. Re: Feed Tableau with Power BI..... is it just a dream?
          Rob Palmer

          Hi Jimmy,

           

          What type of transformations do you need to do? Tableau can do a limited amount with iterating over flat files at the moment, so depending on that you might well be able to do everything you need in Tableau.

           

          If it is too complex then I would create a SQL database (if the data is small enough you might get away with Express edition) to host the data. Then use SSIS to feed the data from the flat files (using a for loop to go through each file) and perform the transformations that you need. This will then create the clean data set you are after.

           

          Cheers

          Rob

          • 2. Re: Feed Tableau with Power BI..... is it just a dream?
            Sasha Hanna

            Hi Jimmy,

            You could perform both data preparation steps and visualisation in Tableau. For example, you can bring files from multiple data sources via joins and unions, you can split concatenated fields and even pivot data. You can also refresh the data (make Tableau look at new files in your folder) without having to load it. Could you describe the transformation process you take?

             

            As for connecting straight to Power BI to Tableau it might not be possible but I found a blog post where the users connect to Power Pivot https://powerpivotpro.com/2014/11/power-bi-and-tableau-best-friends-forever/

            Is this what you are trying to attempt?

             

            Cheers,

            Sasha

            • 3. Re: Feed Tableau with Power BI..... is it just a dream?
              Mahfooj Khan

              Hi Jimmy,

               

              Why don't you use any database ETL tool to prepare your data instead of doing it in Power BI? It'll be easy to manage then its up to you use Power BI or Tableau for any visualization out of that.

               

              Mahfooj

              • 4. Re: Feed Tableau with Power BI..... is it just a dream?
                Andrés Salazar

                Hi Jimmy, Here's an explanation of how to connect (Not to Power BI, but to PowerPivot, the father of Power BI)

                you can not directly connect  Power BI to Tableau.... But....

                 

                What you can do is:

                1. Create your query in Power BI

                2. Open an Excel workbook (Excel 2013 pro plus or excel 2016)

                3. Open Power Query (Excel 2013) or Data Conections (Excel 2016)

                4. Copy / Paste the query from Power BI to Excel (Yes! You can do that!)

                copyquery_PBI.PNG

                pastequeryinexcel.PNG

                5. Once you load the queries you need to add them to the data model (Power Pivot)... right click on each query and "Load to", then Click on a little square that says "Add to data Model".

                LoadqueryinPowerPivot_forExcel.PNG

                6. Done! you replicate your Power BI queries into PowerPivot for Excel.

                7. There is a native connector for Power Pivot in Tableau, you can connect to the Excel workbook and you will have the queries created. You can also write DAX code in Excel (With some limitations).

                 

                powerpivot_connector.PNG

                This is how you can reuse Power BI DataModels and Measures (Copying them to Excel Power Query and Power Pivot).

                Power Query and Power Pivot are the mother and father of Power BI. You can do your ETL in Power Query for Excel, or do it in PBI and copy/paste the query.

                 

                Give it a try, and if this was the answer you were looking for the let me know!

                 

                Best,

                Andrés Salazar