Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a tabular cube created in Visual Studio Professional 2022 (created with the 'Microsoft Analysis Services Projects' extension). I created parameters for my data source (an Azure SQL MI instance). When I'm in the expression editor (Power Query Editor), I can see my parameters as items in my query list. But, when I access Query \ Manage Parameters, none appear. And, after I deploy my cube to a Power BI workspace (under Premium capacity), when I try to configure deployment rules in a deployment pipeline, I only see an option for 'Data source rule'; 'Parameter rules' is disabled.
How can I resolve this? That is, how can I make my parameters actually act as parameters, i.e., to appear in Manage Parameters in Visual Studio and to give me the 'Parameter rules' option in a deployment pipeline in the Power BI web service?
Parameters in Visual Studio:
Deployment Rules in Power BI Service:
I'm confused. As far as I know, there is no such thing as a 'Parameters' section (folder) in Visual Studio. The closest thing to that is the 'Expressions' folder, which contains my parameters. I just inspected by Model.bim file in Tabular Editor, and Tabular Editor also doesn't have a 'Parameters' section or folder. It's named 'Shared Expressions' in Tabular Editor. I compared the M query of a parameter in Power BI Desktop to that in Visual Studio. They're nearly identical. The only difference is that a parameter in Power BI Desktop doesn't involve a "let ... in" statement. Interestingly, I tried removing the "let ... in" statement, and doing so allows me to view the parameter in the Manage Parameters window. But, as soon as I exit the Power Query Editor window, it reverts back. So, perhaps I'm not creating parameters correctly in Visual Studio. What is the correct way to create parameters in Visual Studio? If it matters, I'm using parameters for my data sources (as opposed to, say, fields).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.