User Profile

bhavana_dfz

Frequent Visitor

Joined 1 year ago

8 Posts1 Solution

View All Badges

User Widgets

Contributions

Re: RE: Measures created using XMLA end point
Thank you for answering my question Anonymous . I have a follow up. Why is viewing and editing measures not an issue when semantic models are published via power bi desktop? I can connect 'live' to those publilshed semantic models from my desktop again and view measures after they are published. How are models published via XMLA end point different from those published via desktop ?
1 year ago Place Service
1.1KViews
0likes
0Comments
RE: Measures created using XMLA end point
I have created a Data definition using .Net TOM library and published the dataset to a workspace using XMLA end point. I have created a measure using the format stated below: public int AddMeasures(IEnumerable<MeasureInfo> measures) #####--------------------- { var table = EnsureTableExists(); int count = 0; foreach (var item in measures) { if (!table.Measures.ContainsName(item.Name)) { var newMeasure = new Measure { Name = item.Name, Expression = DaxExpression, // Dax expression IsHidden = !item.Visible, DisplayFolder = item.FolderPath }; table.Measures.Add(newMeasure); count++; } } return count; } --------##### But when i connect to the published semantic model in Power BI Desktop, I am unable to edit the measures; by that I mean, when one clicks on the measure you get to see the underlying DAX Expression, which user can edit/delete it if needed. This is missing for the measures CREATED via XMLA end point. Is this how it is supposed to be , are the measures created via XMLA end point, read only ?
Solved
1 year ago Place Service
General Comment
Need Help
1.1KViews
0likes
2Comments
Re: XMLA Endpoint Enabled but Getting “XMLA Endpoint Feature is Disabled” Error in C# Connection
The issue is resolved, it was the admin tenent settings which needed some tweaking.
1 year ago Place Service
2KViews
0likes
0Comments
XMLA Endpoint Enabled but Getting “XMLA Endpoint Feature is Disabled” Error in C# Connection
Hi all, I'm encountering an issue when trying to connect to a Power BI semantic model via the XMLA endpoint using C#, following the guidance in Microsoft’s documentation. Despite having the XMLA endpoint enabled for our tenant, I’m still getting the following error: Microsoft.AnalysisServices.ConnectionException: XMLA endpoint feature is disabled. Turn on Analyze in Excel feature in PowerBI.com to enable this feature. I’ve double-checked that: The XMLA endpoint is indeed enabled at the tenant level via the Power BI Admin portal. I'm using a Premium or Premium Per User (PPU) workspace and I am the admin of the workspace. I have Build permissions on the dataset. The user account has sufficient privileges and the "Analyze in Excel" feature is enabled in PowerBI.com. i am following this documentation : Programming Power BI semantic models with the Tabular Object Model (TOM) | Microsoft Learn Does User's fabric capacity play any role in this error
Solved
1 year ago Place Service
General Comment
Need Help
2.3KViews
0likes
4Comments
Re: Push Datsets using Power BI REST API
Hi v-venuppu, Thank you for the detailed explanation. I understand now that Push Datasets are not suitable for scenarios requiring incremental refresh or scheduled updates, and that they lack support for external data source bindings like Azure SQL. Just to clarify my original intent: I was exploring the Push Dataset API as a way to create a refreshable the data source definition in Power BI during a report migration from another BI tools. My goal was to streamline the migration by programmatically creating and updating datasets. Given this, is there a recommended approach or toolset (such as XMLA, Tabular Editor, or other APIs) for programmatically creating and updating datasets that are connected to an external source like Azure SQL—while still supporting refresh and incremental loading? Appreciate your guidance, and thanks again for your support. Best regards,
1 year ago Place Developer
2.9KViews
0likes
0Comments
Push Datsets using Power BI REST API
I want to use rest api to create a dataset definition in using REST API ( REF : Push Datasets - Datasets PostDataset - REST API (Power BI Power BI REST APIs) | Microsoft Learn). But the datasets i created using this method are readonly and do not refresh. I want to Create a dataset that supports incremental refresh Data source is Azure SQL Database. I want to be able to manually trigger a refresh from the Power BI Service or API when the database updates in my source. The API mentions something about DataSources but its vauge, has anybody tried this method to create a Push Dataset?
Solved
1 year ago Place Developer
General Comment
Need Help
3KViews
0likes
4Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.