Forum Discussion
Azure ML odata & Refresh
I used PowerBI Desktop to score a model from AzureML..
I am using 2 data sources Azure SQL Database and OData from AzureML.. This link describes it the procedure to score from AzureML
I create a function to score the data from Azure SQL database with the OData from AzureML. Everything is working and refreshing in PowerBI Desktop. Store the file in OneDrive and upload it to Service. Entered the credentials for the sources - no warnings. I Refresh Now, the refresh succeeds but I have no data coming from AzureML OData..The scoring table (function) is empty. So I have no warning to know what is going wrong.
Is not supported due to credentials entered ( AzureML Odata - Basic with API key ) ?
Did anyone tried it?
Thanks
Okay, I guess I was wrong when I said that I couldn't think of a reason this wouldn't work.
When you run this inside Power Query or PBI Desktop, you either have to enable "Fast Combine" or you need to set privacy levels for the two sources. Currently, all sources inside refresh are marked as "Private" with no ability to change this configuration or set "Fast Combine". This prevents the query from working correctly. This was picked as a default to maximize security without asking the user hard-to-explain questions, but it's obviously quite limiting in the kinds of queries that can be performed -- so we need to figure out how best to enable this scenario for refresh.
8 Replies
Have not tried it, but thanks for the link and idea, now I've got to try it. I have a bunch of experiments I've been doing in Azure ML so this has given me all kinds of ideas! I'll try it and let you know.
Glad I help...I am expecting your results..:manhappy:
FYI the functions are not a problem as they are refreshing .. ( tested )
I know of no specific reason why this wouldn't work. Can you post your query or send it to me in a private message?
