Power BI Integration

follow this guide to learn how to integrate your hunni data into power bi setup if you don't already have power bi desktop, you can download it from the microsoft download center create api credentials see api overview docid\ pnvqvxpt9ezj2kwt3lv49 turn off automatic relationships in power bi (optional) this will prevent power bi from automatically creating relationships between columns with the same names i e "hunni id" go to file file > options and settings > options > current file data load > uncheck "autodetect new relationships after data is loaded" 1\ in power bi, click get data > blank query 2\ name query "gettoken" by double clicking or right clicking > rename 3\ in hunni, copy the token query from the expanded grid navigate to the table or view you wish to integrate into power bi and click the power bi button located at the top of the expanded grid next, copy your token query this query contains your api key and secret keep this information secure by password protecting your power bi file 4\ paste token query into gettoken query in power bi 5\ click new source > blank query name it the asset you are querying 6\ in hunni, copy asset query from expanded grid 7\ paste asset query into query from step 5 privacy levels click continue to set or ignore privacy levels on this query more information information on power bi privacy levels can be found here 8\ detect data types select all columns in your table (select any cell in table > ctrl+a) click transform menu on ribbon click detect data types 9\ repeat steps 5 8 to add more assets to add more assets, open them in the expanded grid and repeat steps 5 8 you do not need to add the token query again 10\ click close & apply after clicking close & apply , your assets will be avilable in your data model you can then create relationships between your tables in the model view or start building visuals with your data in the report view power bi get started documentation if your assets structure changes i e column names change or columns are added/deleted, you will need to update your query troubleshooting authentication issues if you are having trouble authenticating, you may need to clear your cache in file >options and settings >data load