Forum Discussion
Solved
Create relationships with REST API datasource
Hi, I have a dataset provided via a REST API from my energy supplier. I want to be able to drill down year > month > day > hour. Power BI detects the date/time column as Date Hierarchy, but does...
The "Manage Relationships" button was greyed out because I only had one table.
The guide I was following assumes a certain amount of knowledge.
I had to create new "Dimension" tables from the "Time" and "Date" columns in the "Fact" table:
Every day's a school day!
The "Manage Relationships" button was greyed out because I only had one table.
The guide I was following assumes a certain amount of knowledge.
I had to create new "Dimension" tables from the "Time" and "Date" columns in the "Fact" table:
Every day's a school day!