Forum Discussion

Krishnamurthy's avatar
Krishnamurthy
Frequent Visitor
4 years ago

How to import both Azure sql server data and a power bi Live connection data into a single power bi

I have a Power BI desktop file. The following are the data sources

1:) Azure Sql database

2:) Local Sql database

3:) Excel file for mapping the above 2 databases

Now i have some data in another Power BI being published by another team, which is a input for me. How can i get this Live connection into my power bi?

I tried the analyze in excel option but i am getting a memory error due to the large volume of data. Need help on this

Dataflow
Need Help

1 Reply

  • collinq's avatar
    collinq
    Super User
    4 years ago

    HI Krishnamurthy ,

     

    According to this article: Use composite models in Power BI Desktop - Power BI | Microsoft Docs you can't combine Live Connect with your existing reports (assuming you are not live connect right now on the other SQL):

    "The following Live Connect tabular sources can't be used with composite models:

    • SAP HANA
    • SAP Business Warehouse
    • SQL Server Analysis Services
    • Power BI datasets
    • Azure Analysis Services"

    I am wondering if you can take the other report, make it a dataflow and then use the dataflow as your input?  I think that takes away the "live" part of it?  Or, I am wondering if you can just combine the two reports into a dashboard, rather than at the report level?