Forum Discussion

aaldo_666's avatar
aaldo_666
Helper I
4 years ago
Solved

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.

Thanks.

Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.