Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Importing data from 'Ask Nicely'

I am trying to import data from Ask Nicely to create a PBI report.  I am currently using the get data web function in attempts to import data from API's.  I do not know much about API's but I was able to successfully import the data from each API node, the problem is none of the data can be linked via relationship within PBI.  Is there another way to achieve what I am attempting?  Ideally, a complete data dump would be best I suppose...

Need Help
Tutorial Requests

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    Could you please post the error message that you get when creating relationships in Power BI Desktop?

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am not receiving an error. there is no common data between the sets.  

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Anonymous,

        Then why do you need to create relationship between the tables as there are no common data? You can manually create a table containing all the values of  the columns in each table, then create relationship between this new table and each existing table.

        If you still have questions, please share sample data of your tables and post expected result.

        Regards,
        Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous,

    How is the issue going?

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      My next step is to reach out to the website to see if I can get a more thorough data dump.