Microsoft Power BI Insights: AI transformation credentials; Analysis Services vs. PBI Premium; CPU management; Power Query troubleshooting; Querying

Power BI pros share their latest insights, from how to manage AI transformation credentials to querying Power BI reports with Analysis Services and more.

Managing AI transformation credentials

In the November release for Power BI Desktop, Microsoft introduced AI Transforms in PowerQuery. According to David Eldersveld, writing on DataVeld these apply to Azure Machine Learning, Vision, and Text Analytics. To align with AI Insights features already available in dataflows, Microsoft requires that users be signed up for Premium capacity to actually use AI Transforms.

Eldersveld cautioned that those who switch frequently between Power BI Desktop accounts may have problems, because of data capacity mix ups. He wrote:

After some initial confusion, I learned that the credentials for AI Functions are managed under Data Source Settings. To login as a different user to access dedicated capacities, you have to do this from Data Source Settings rather than the AI window. This is similar to Power BI Dataflows authenticating as the stored credentials under Data Source Settings rather than the user logged into Service overall in the top right corner.

Comparing Analysis Services and Power BI Premium

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access

or login