Send to power bi - Microsoft connection node problem

[ElioPT]

Hello,

I´m starting to use Knime , and i’m having problems in microsoft connection. clicking in the node, dont show the configure menu … How can I open the configure menu?

Thanks

[ScottF]

Hi @ElioPT and welcome to the forum.

Generally in KNIME AP you can either double-click the node to open its configuration, or you right click and select Configure from the context menu.

If you’re still having trouble, maybe post some more details (even a screenshot) about what you’re seeing?

[ElioPT]

Hello,

thanks for Your reply. When I click in the authentication node nothing happens. When I right click, and open the configuration I dont have that menu

[ScottF]

Looks like you are using KNIME Version 5 - cool, glad you are trying it out. I went ahead and checked to see if I could replicate the problem. I think you are just missing an executed Microsoft Authenticator upstream (make sure when you configure, you scroll down to check the box in the “Request access to” section for Power BI).

Of course you will also need to feed in a KNIME input table to the bottom input port of the Send to Power BI node, which I’ve not done here.

[ElioPT]

Thank You!

Yes, Im using V5. Yes, i was missing that node. But now, I need another one, and dont know what is it… Extract one table from database…

[ScottF]

If you’re just trying to read a single table from your DB into KNIME, those results should be available at the output port of the DB Reader node.

Are you trying to send the results of the extraction to PowerBI? Then connect the output of the DB Reader to the PowerBI. Otherwise, I’m not sure what you mean.

[ElioPT]

Hello. Yes, I was trying to do what You guess, but with no results. Now in the fresh of morning I discover why. My table has 90 columns and BI API only support 75.

Thank You.