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

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?

      • jesus21282's avatar
        jesus21282
        Frequent Visitor
        4 years ago

        Hi Anonymous if I remember correctly, you must take a query from the Existing broken refresh dataflow and paste the query into the NEW dataflow, then Save it and refresh it. Let me know if that works