Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ashvin
Frequent Visitor

Connecting Azure Machine learning models in PowerBI desktop (NON_premium account)

Hello,

 

I tried to access my ML models( from ML workspace) inside PowerBI desktop using a NON-PREMIUM account but didn't see any models listed in my powerBI desktop. I did grant access to my powerBI id under Access Control (IAM) of my ML workspace and subscription list.

 

As per Microsoft (link below), text analytics and cognitive services are for premium id only. Is it the same for ML models or I am missing something?

 

Has anyone tried to access ML models with NON-PREMIUM id?

 

Nov release- https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2019-feature-summary/#aiFunctions

7 REPLIES 7
CB2022
Employee
Employee

Did you guys check the "Scoring Script" which is mandatory for the PowerBI , AML integration ? 
Tutorial: Create the predictive model with a notebook (part 1 of 2) - Azure Machine Learning | Micro...

aespin
Regular Visitor

Hi! Does anyone have a solution for this? 

 

I have deployed an endpoint, which is up and running, and I'm trying to use this endpoint in Power BI Desktop as per this tutorial https://docs.microsoft.com/en-us/power-bi/connect-data/service-aml-integrate?context=azure%2fmachine... in the section "In the Home ribbon of the Power Query Editor, select the Azure Machine Learning button".

 

The deployed endpoint does not show up in the list, nor does it show up in the AI Insights list in power query online when using dataflows.

 

I had no luck with a pro account or the premium trial.

dax
Community Support
Community Support

Hi ashvin, 

Based on my research, I find that "This functionality is currently only supported for Power BI dataflows, and for Power Query online in the Power BI service."

You could refer to Azure Machine Learning integration in Power BI  for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ashvin
Frequent Visitor

Hello @dax ,

 

The link you have shared is of May 2019, but after November 2019 update this option is available in desktop version- Power Query Editor.

 

I have a pro account and I am not able to access the ML models in PBI desktop. In the link that I shared earlier its mentioned that Text analytics and Cognitive services are Premium only features but no comments about ML models. My guess is ML is also a Premium only feature, but there is not documents to verify this.

 

 

 
ashvin
Frequent Visitor

I figured out the problem, my container instance corresponding to the ML model in azure portal was not running and so the models were not visible in PBI desktop. After switching them ON, my ML models are now accessible in PBI desktop.

 

 

ashvin
Frequent Visitor

Hello @dax ,

 

I am having the same problem even when my container instances are running. 

Performed a stop/start operation on my container instances and still the same problem. 

 

Do you have any advise?

Anonymous
Not applicable

@dax do you happen to have any solution for this? I am also having similar issue, I have read access to model and and everything is up and running but I am not able to see any models in desktop.

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors