Forum Discussion
PBIP Git Integration Errors
Field parameters are supported.
Did you add the extended properties by yourself using Tabular Editor or using Power BI Desktop? Can you share a bim file?
Yes, I added the external properties myself with tabular editor. My use case involves using the same PBIX for many environments so I have the need to dynamically populate my field paramters. I achieve this by importing a SQL table that mimics the structure of a field parameter table with the extended properties added to the imported table. BIM file attached.
Not sure if I can attach files here so here is a link to a public repo with the model.bim: dlomartra1/powerbi-git-example (github.com)
- RuiRomanoMS3 years agoMicrosoft Employee
I'm assuming you can deploy your BIM file using XMLA and work with the field parameters in the service, correct?
Have you compared your bim file and extended properties to the extended properties and annotations produced by Desktop for field parameters? Asking because field parameters work fine with PBIP and Git Integration when created from Desktop, if you do exactly the same manually it should work fine.- dlomartra3 years agoFrequent Visitor
Yes, the power bi file with the manually implemented field parameter works fine in power bi desktop and in the service. The only difference I can see between this and one generated by Power BI desktop is that the power bi desktop field parameter table is manually created and mine has a SQL query as a source because it comes from a table in snowflake. Mine does also have one additional column with a second sort value.