Data Source without Gateway cluster name

[aaldo_666]

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.

Thanks.

[v-yanjiang-msft · Accepted solution]

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.