Forum Discussion

ctelya's avatar
ctelya
Frequent Visitor
8 years ago

QuickBooks Online (QBO) Connection - How to Access Service DAX on PBI Desktop

Hello,   I've connected a QBO company to PBI Service and Desktop. The Service has several pre-created measures and a report. I'm trying to replicate the DAX on Desktop to replicate the report and a...
Need Help
Tips and Tricks
Tutorial Requests
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ctelya,

We can create measures in Power BI service, so somebody must publish it from Power Bi desktop. And we can not see the formula measure used. But you can select the Dateset->Download .pbix file(please see the screenshot shown), you will get pbix file with detailed information, you will see the specifc formula.

 



Best Regards,
Angelia

ctelya's avatar
ctelya
Frequent Visitor
8 years ago

Hi v-huizhn-msft, 

 

Thanks for your response! I don't have the option to download a .pbix file. The report was not created in Desktop or by me - it is a pre-prepared one by Power BI. When you connect a QuickBooks Online company to the PBI service, the report/dashboard is automatically generated and has several pre-created measures. I want to access those measures in PBI Desktop.

 

Best,

Christina

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi ctelya,

    Even you can connect QuickBooks Online, you can see the measure there. There are some limitations for export .pbix file, please see the Considerations part in this article. 

    Best Regards,
    Angelia

    • ctelya's avatar
      ctelya
      Frequent Visitor
      8 years ago

      Hi Angelia,

       

      I don't believe that article is relevant to what I'm asking.

       

      I just want to be able to view the formulas used for the measures in the QBO content pack on PBI online. As I mentioned before, these are pre-created by Power BI, but I want to use them in Power BI Desktop. When I connect my QBO company to Desktop, the measures are not available.

       

      Best,

      Christina

       

       

      • KiranShah's avatar
        KiranShah
        New Member
        8 years ago

        Hi

         

        I am having the same issue... i need to see the measures.. did you ever get this resolved?

         

        Kiran