cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aaldo_666
Frequent Visitor

Data Source without Gateway cluster name

I have on-prem Gateway. But few data sources have no Gateway cluster name and I cannot add users to them.

What are these ohter data sources? Do I need them?

For example I have data source Dataflows for power bi data flows, where I can add users and {"extensionDataSourceKind..."} where I cannot add users and no gateway cluster is assigned.

aaldo_666_0-1655883569368.png

Thanks.

1 ACCEPTED SOLUTION
v-kalyj-msft
Community Support
Community Support

Hi @aaldo_666 ,

Based on my research, please try these suggestions:

A. Enable "Allow user's cloud data sources to refresh through this gateway cluster" in your gateway cluster settings as per: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

B. Follow the below steps:

  1. Go the Create Dataflow page.
  2. Select "Add new Entities"
  3. Select "Blank query"
  4. Select the "On-Premises Data Gateway" that you wanted to use for the above dataset.
  5. Now we must paste a query that was generated in the PowerBI Report in PowerBI Desktop.

5a) Open up the report in PowerBI Desktop.

5b) Go to Transform Data.

5c) Select a query from the dataflow and click on Advanced Editor

5d) Copy the Entire query

  1. Paste the query and hit next
  2. Click "Configure Connection"
  3. Use Authentication Kind: "Organizational Account" and sign in as yourself.
  4. Save & close
  5. Now you can go back to the dataset settings page you should be able to map 'Extension{"extensionDataSourceKind":"PowerBI","extensionDataSourcePath":"PowerBI"}' to 'PowerBI' and hit apply

Best Regards,
Community Support Team _ kalyj

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

View solution in original post

1 REPLY 1
v-kalyj-msft
Community Support
Community Support

Hi @aaldo_666 ,

Based on my research, please try these suggestions:

A. Enable "Allow user's cloud data sources to refresh through this gateway cluster" in your gateway cluster settings as per: Merge or append on-premises and cloud data sources - Power BI | Microsoft Docs

B. Follow the below steps:

  1. Go the Create Dataflow page.
  2. Select "Add new Entities"
  3. Select "Blank query"
  4. Select the "On-Premises Data Gateway" that you wanted to use for the above dataset.
  5. Now we must paste a query that was generated in the PowerBI Report in PowerBI Desktop.

5a) Open up the report in PowerBI Desktop.

5b) Go to Transform Data.

5c) Select a query from the dataflow and click on Advanced Editor

5d) Copy the Entire query

  1. Paste the query and hit next
  2. Click "Configure Connection"
  3. Use Authentication Kind: "Organizational Account" and sign in as yourself.
  4. Save & close
  5. Now you can go back to the dataset settings page you should be able to map 'Extension{"extensionDataSourceKind":"PowerBI","extensionDataSourcePath":"PowerBI"}' to 'PowerBI' and hit apply

Best Regards,
Community Support Team _ kalyj

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10

The Power BI Community Show

Join us on October 3 at 11 am PST when Amit Chandak, a Power BI Super User, will demo how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors