Forum Discussion
Missing fields from data feed when connecting directly to Outlook calendar
Hi,
I am using PBi to connect directly to my outlook calendar. This is working find to most of the times, but I noticed that the "Categories" variable is not being passed across and made available to use.
When I look at the data source fields, I can see that "Categories" are there. Even when I initially connect to the data source, it shows as a "list" type field, but I dont see it as an available field in PowerBI
Hi Ruka , you have to expand the categories list using the two options that Power BI gives you:
If you select Extract to New Rows it will create one row per categorie listed. If you select Extract Value, you can concatenate each categorie with a separator such as comma, for instance, as shown below:
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
1 Reply
- joaoribeiro
Impactful Individual
Hi Ruka , you have to expand the categories list using the two options that Power BI gives you:
If you select Extract to New Rows it will create one row per categorie listed. If you select Extract Value, you can concatenate each categorie with a separator such as comma, for instance, as shown below:
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro