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

[Anonymous]

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

[v-jiascu-msft]

Hi @Anonymous ,

1. Which version do you have?

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

Best Regards,

[Anonymous]

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]

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.

Best Regards,

[v-jiascu-msft]

I have reported it to the Product Team: CRI 105940057.

Best Regards,

[Anonymous · Accepted solution]

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

[Anonymous]

Ah well, I suppose it makes sense. Thanks Amit!

So let me get this straight - there is no way to use data from one dataset in another report in the ETL process? To get the resulting table of a few thousand rows I need to replicate the query that runs for a good 15 minutes and processes millions of rows for each report I want to use the table in?

[v-jiascu-msft]

Hi @Anonymous ,

Maybe you can download the pbix file from the Service and use it directly?

Best Regards,

[Anonymous]

Hey Dale,

Unfortunately I need the reporting environment to run at least weekly refreshes so any kind of manual steps are out of the question. I'll need to see what I can come up with, this is not a critical issue yet. I just assumed that this kind of capability to use existing datasets in other reports would be amongs the first things implemented with any kind of online BI system.

[v-jiascu-msft]

Thank you, Amit. That makes sense.

Best Regards,

[Anonymous]

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