Forum Discussion

jason435's avatar
jason435
Helper II
7 years ago
Solved

Gateway extenionDataSourceKind Power BI error

When I upload a report I receive the following error when selecting my gateway in the dataset settings:   Extension("extensionDataSourceKind":"PowerBI","extensionDataSourcePath":"PowerBI") Cannot ...
Need Help
  • jason435's avatar
    jason435
    7 years ago

    Too troubleshoot, I turned off all the 'include in report refresh" in power query for the tables connected to a dataflows. Uploaded and to and check to see if refresh worked. It did. Then I turned them all back on, and everything worked. No idea...

jesus21282's avatar
jesus21282
Frequent Visitor
4 years ago

Still having this problem. In Desktop, disabling the dataflow-dependent queries from "Include in report refresh" won't work either. The option "Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster." is also enabled and it won't work either.

 

Does anybody have a solution for this yet? I have tried reaching out to MS Support but so far they still can't find the issue.

jesus21282's avatar
jesus21282
Frequent Visitor
4 years ago

Finally solved this issue, after several meetings with MS Support.

 

These were the steps followed:

Analysis and Resolution:
===================
---> We saw that after you updated the gateways to the latest version the datasets were not refreshing which contained the dataflows as the datasource.
---> The gateway mapping was not allowing to use the dataflows source to add and apply to refresh and was giving error
---> After investigation it was understood that it is a bug from our end and our PG team is working on it to resolve the issue
---> But as it was taking a longer time, an alternate solution was provided for mitigating the issue. Below are the steps followed to resolve the issue :

  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
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi - working through this issue for my gateway. 

     

    For step 5 - where are you pasting the query that you created and copied?

    • jesus21282's avatar
      jesus21282
      Frequent Visitor
      4 years ago

      Hi Anonymous it must be pasted in the Blank query specified in Step 3.:

      1. Go the Create Dataflow page.
      2. Select "Add new Entities"
      3. Select "Blank query"  <---- Here is where you paste the query created

      Let me know if it works.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thanks for your response jesus21282 .  Still not clear to me.  the way I'm reading your instructions you are doing two things - 1. creating a new dataflow 2. pasting a query from a dataflow into the new dataflow.  Where I'm confused is are you suggesting that a dataflow table from the NEW dataflow be copied and pasted back into a query for that dataflow?  Or, are we to take a query from the existing broken refresh dataflow and paste the query into the NEW dataflow?