Forum Discussion

kosmik5's avatar
kosmik5
Regular Visitor
8 years ago
Solved

Connect Power BI Desktop to insightly

Hi,

    

It doesn't seem possible to connect Power BI Desktop to Insightly although there's a content pack for Power BI Service. Is there a workaround, if we need to build a data model and/or add calculated measures?

 

 E.g. use the content pack for the service and then connect Desktop to Power BI service?

 

Or any better suggestion?

 

Thank You

Hari


  • kosmik5 wrote:

    Hi,

        

    It doesn't seem possible to connect Power BI Desktop to Insightly although there's a content pack for Power BI Service. Is there a workaround, if we need to build a data model and/or add calculated measures?

     

     E.g. use the content pack for the service and then connect Desktop to Power BI service?

     

    Or any better suggestion?

     

    Thank You

    Hari


    kosmik5

    You can connect to datasets in Power BI Service from Power BI desktop. See this link. However 


    You may not see every dataset that is available to you in the Power BI service, the datasets you'll see listed are:

    • Datasets you have edit access to. These include datasets you've created or datasets you have edit access to in a shared workspace. Datasets created from service content packs should show up in this list as well.
    • Datasets coming from data sources via import, DirectQuery or Push. We do not yet support SSAS data sources via this method, but it is on our roadmap to support this as well.
    • Datasets from Organization Apps once you've made a copy. In order to get edit access to a dataset in an org app, you first need to make a copy.



1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft Employee

    kosmik5 wrote:

    Hi,

        

    It doesn't seem possible to connect Power BI Desktop to Insightly although there's a content pack for Power BI Service. Is there a workaround, if we need to build a data model and/or add calculated measures?

     

     E.g. use the content pack for the service and then connect Desktop to Power BI service?

     

    Or any better suggestion?

     

    Thank You

    Hari


    kosmik5

    You can connect to datasets in Power BI Service from Power BI desktop. See this link. However 


    You may not see every dataset that is available to you in the Power BI service, the datasets you'll see listed are:

    • Datasets you have edit access to. These include datasets you've created or datasets you have edit access to in a shared workspace. Datasets created from service content packs should show up in this list as well.
    • Datasets coming from data sources via import, DirectQuery or Push. We do not yet support SSAS data sources via this method, but it is on our roadmap to support this as well.
    • Datasets from Organization Apps once you've made a copy. In order to get edit access to a dataset in an org app, you first need to make a copy.