Microsoft BI Connector

[mmurph200]

When I run my workflow with the power bi output it won't let me select a workspace so I can configure the options does anyone know why? See attached Image.

[Qiu]

@mmurph200 
I am not sure this will help but take a look.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Power-BI-Ouput-Error-Loading-w...

I tried on my pc, it works just fine.

[JimmyV]

Hi mmurph200,

Based on your screen shot, the Workspace drop-down is greyed out. Which to me means that you might not even have a "My Workspace" option indicating that you may not have a Power BI Pro license.

To confirm if you have a Power BI Pro license:

• Go to the Power BI Online Service site: https://app.powerbi.com/home

• At the top right of the web page go to the top right and click on your icon, which will open up the following section below. 

  

If you have a Power BI Pro license, I would recommend reaching out to your Power BI Admin to grant you access to Power BI's API. Below are screen shots to show what is needed to provide access to output to Power BI service. Also, thank you for posting this question! I never knew about this tool up until now! It was pretty easy to build out a quick dataset to test!

Screen shot of what is needed on the Power BI Admin side:

• Allow service principals to use Power BI APIs to be enabled
• If the access is specified to a specific security group, request access to one of those groups or be added directly to have access.

Screen shot of instructions from the Microsoft Power BI help link to help your Power BI Admin grant the access needed.

Best of luck!

[RashiChouhan]

I think, there is a permission issue, only members with appropriate permissions, such as "Member", "Contributor", or "Admin", can publish or update reports in a workspace.

To solve this, you check your permissions for the workspace. If you're not sure about your permissions, contact your msbi course admin or the owner of the workspace.

And the second reason might be the workspace version- MSBI has introduced newer versions of workspaces (https://community.fabric.microsoft.com/t5/Community-Blog/Power-BI-New-Workspace-Experience-Power-BI/...) (like V2), and some features or settings may not be available or may function differently in older versions. To solve this, ensure that you're working in a modern workspace. If you're still using a classic (V1) workspace, consider migrating or creating a new one.

Thanks