Importing data from 'Ask Nicely'

[Anonymous]

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...

[Anonymous]

@Anonymous,

How is the issue going?

Regards,
Lydia

[Anonymous]

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

[Anonymous]

@Anonymous,

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

Regards,
Lydia

[Anonymous]

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

[Anonymous]

@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