Send to Power BI - Formatting ( % )

Hello,
I am using the “Push to Power BI” node, and my dataset contains percentages.

When I display those percentages in a Power BI report, they are displayed as regular numbers ( 0.05 instead of 5% ) and it looks like this should be specified in the dataset metadata, using the formatString parameter ( link ) which is not configurable in the KNIME node.

Could you please add that, or help me find a workaround?

Thanks
Sébastien

Hi Sébastien,
Currently I don’t know any way to do this except using the REST API yourself with a POST Request node. one thing that might work for some use cases is that you create a dataset in Power BI and set the Send to Power BI node to append to that dataset. Then you could set all the formatting options in Power BI on the empty dataset before the actual upload. But I don’t know enough about Power BI to tell you that this will definitely work. Maybe you can try it?
How have you formatted the number in KNIME? Are you storing it as a string cell? Because for numbers there is no way to show the % in KNIME either, if I am not mistaken.
Kind regards,
Alexander

Hello,

I solved it similarly to what you are describing.
I created the “push dataset” myself using the API ( I could have done it using the POST Request node but I would have struggled with authentication since I don’t think I can use the one from the “Send to PowerBI” node* )

I actually used the “try it” feature in the Microsoft Docs: Push Datasets - Datasets GetTablesInGroup - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Once the “push dataset” was created with the correct formatting I could fill it with the Knime “Send to PowerBI” node.

*: it would be another nice feature to split the “authentication” into another node so that we can use the token in other nodes.

2 Likes

Hi Sébastien,
Thank you for sharing the solution with us. I agree that splitting the authentication might be helpful!
Kind regards,
Alexander