Using Live Quickbooks Online Data in a Canvas App using a Connector?

[MarkSlosberg]

A little background.  I have been struggling with this connector for months (and months) and had basically given up but decided to try again and, lo and behold, it suddenly was working and not only that, working well but, so far, only from PowerBI Desktop which is good but only part of the way there.  

While this is a great start (finally), what I really need is to access this QBO data from within a Canvas App (and probably a Flow shortly) to implement some data integration and synchronization actions between my PowerPlatform app and QBO.  I thought I would be able to turn a "published" Semantic Model and Report in Power BI Services (now Fabric) into a Dataflow but so far that step has eluded me. I am not certain if the behavior I am seeing is intentional (meaning I am not using it correctly) or if I have caught the PowerPlatform team (Power Apps and Power BI) in a transitional state where something now works in one part (PowerBI Desktop) but is not yet available for Enterprise use via PowerBI Services (now Fabric).

I have a working Semantic Model and Report that brings live Quickbooks Online data into both Power BI Desktop and Power BI Service (Fabric).  The weird thing is that I can only see the Connector in Power BI Desktop.

It is completely visible in Fabric (Power BI Services) after I publish it and the Report works perfectly.

My question is: How can I turn the working Semantic Model into a Dataflow visible in my Power Apps Studio?

Alternately, when I try to create the Dataflow directly using the Fabric (Power BI Services) interface it is not finding the QBO connector (above)

Anyone, anywhere seen this behavior before?

[Anonymous]

Hi, @MarkSlosberg 

To your question, so far, it is not possible to turn the working Semantic Model into a Dataflow visible in the Power Apps Studio. You can take a look at the following document: Solved: Can i directly use PBI dataset / Dataflow under Po... - Power Platform Community (microsoft....

However you can use the SAP connector to connect  to your data.

If you want to learn more about SAP Connector, you can check out this document: Introducing the SAP ERP connector | Microsoft Power Apps

Best Regards

Yilong Zhou

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

[MarkSlosberg]

I wi give this a try but I am pretty confused because I don't want to access SAP data but rather QuickBooks Online so I don't really understand how this could possibly work. Plus, the instructions call to install the OnPremises Data Gateway.