Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI Service-option missing from the Data Sources menu in PBI Desktop

Hey,

 

I have succesfully created and published a report for our HR department which has a rather long and complex ETL process where it calculates personnel changes through the last few years. The report updates automatically on the PBI service and appears to be fully functional in all aspects. I'm currently working on a P&L report and I'd like to add the headcount figures to calculate revenue per person. I figured I might simply connect to the existing HR report and pull the data I need to avoid making the P&L's reload more complex than it needs to be. However, when I tried to access the HR report through the data sources I found out that the Power BI Service is not available in the data sources menu. It simply isn't there. The closest one I get is the Power BI Dataflows beta which apparently cannot use a Power BI report as a datasource or at least no such option was available when I tried creating a dataflow to bypass my problem.

 

I tried following this tutorial Step-by-step for using the Power BI service live connectio... but the Power BI Service option shown here simply isn't visible anywhere in the menus. All the other options seem to be there.

 

Any ideas? Do I need to enable it somewhere? I am running February 2019 release of the PBI Desktop and I suppose our tenant ought to keep itself updated automatically. Below are the options I get when searching the available data sources for 'power'. I browsed through the available options and nothing similar to Power BI Service was available.

 

This is what I get

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi v-jiascu-msft , Anonymous 

     

    As we know , Power BI dataset acts as a Live Connection, Anyways, We can't perform any transformation using Power Query Editor.

    Becasue of this , they have removed this from Edit Queries-> Get Data-> Power BI.

    Any idea?

     

    Regards,
    Amit

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Can you Please check your access setting. I think you are you are read only member in taht workspace. Because of that you can't see Power BI dataset.

     

    Thanks,
    Amit

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Anonymous ,

     

    1. Which version do you have?

    2. How about opening the Power BI options directly like below?

    Power-BI-Service-option-missing-from-the-Data-Sources-menu-in-PBI-Desktop

     

     

    Best Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey Dale,

       

      I'm using the February 2019 update (2.66.5376.1681 64-bit (February 2019)) on the desktop and our Service is 13.0.8383.201. I have no recollection of whether the option was there or not prior to updating to Feb19 release as I've only attempted to connect to datasets after updating my PBI Desktop to Feb19.

       

      Br,

      Jussi

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi Jussi,

         

        I found it disappeared in the list if we open it from the Query Editor. So you can open it in the report view as a workaround for now. I will look into for more details. Please refer to the snapshot below.

        Power-BI-Service-option-missing-from-the-Data

         

        Best Regards,