Forum Discussion

damit23183's avatar
damit23183
Microsoft Employee
6 years ago
Solved

Use Existing PowerBI report as Data Source

Hi All,

 

I have 3-4 existing PowerBI reports with no access to their datasources.

 

Now, I will have to use POWER BI Reports as data source to create new PowerBI report using PowerBI Desktop.

 

I have PBIX file to all existing reports.

 

Is it possible to use existing reports as source and create new PowerBI report?

 

If it is possible then how can i achive this?

 

Any suggestion and advise will be helpful.

 

Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    You can connect to Power BI datasets in the Service. However, I believe you can only connect to one at at time.

  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi damit23183 ,

     

    First, you should know that:

    1. Import mode can import data from multi data source like SharePoint, SQL Server database, Azure Analysis Service…
    2. Connect live mode just get entire external mode from SSAS, power bi datasets… , you can just get model from one data source in one .pbix file and cannot model data except new measure

    https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

     

    For this case, you can import data to create reports except power bi datasets

     

    Best Regards,

    Yingjie Li

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    You can connect to Power BI datasets in the Service. However, I believe you can only connect to one at at time.

    • damit23183's avatar
      damit23183
      Microsoft Employee
      6 years ago

      Hi Greg,

       

      Thanks for your response.

       

      Currently, i have one data set made from Azure Analysis Service and Sharepoint, however new data will come from PowerBI dataset of existing PowerBI REport which i have mentioned. Also, i am using composite model (Import Mode in Desktop) to pull all info from different data sources.

       

      Can you please put some lights on how can I get the data from Azure Analysis Service,Sharepoint and 1-2 PowerBI datasets together to create one dashboard?

       

      Thanks

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi damit23183 ,

     

    First, you should know that:

    1. Import mode can import data from multi data source like SharePoint, SQL Server database, Azure Analysis Service…
    2. Connect live mode just get entire external mode from SSAS, power bi datasets… , you can just get model from one data source in one .pbix file and cannot model data except new measure

    https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

     

    For this case, you can import data to create reports except power bi datasets

     

    Best Regards,

    Yingjie Li

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi,

    I'm trying to do this in reverse. I have a .odc database that I was able to upload into PBI Desktop, but now I need to use that database in Report Builder.