User Profile
ddelapasse
Helper I
Joined 2 years ago
User Widgets
Contributions
Question about Report content definition.pbir section attribute
Hi! I've been requested to allow 'cloning' of reports from one workspace to another. The db fields are the same, BUT the modelnames will be different. I've been able to do this within a workspace, but I must be missing some piece to the puzzle when I cross workspace boundaries. I have a good reason to avoid the clone api method and instead am pulling the source content, modifying it and pushing it into a newly created report at the destination. All of this passes thru the apis without error, but the report doesn't show the proper data (even tho it DOES appear to be linked to the correct model). I'm taking the content section by section and updating the model reference guids but I just noticed the "definition.pbir" section contains both the workspace NAME (which seems odd) and then has an ID that I cannot figure out. Can anyone tell me what the "pbiModelDatabaseName" reference is pointing to (I've masked it below but points to a valid looking guid)? { "version": "4.0", "datasetReference": { "byConnection": { "connectionString": "Data Source=\"powerbi://api.powerbi.com/v1.0/myorg/{workspaceName}\";Initial Catalog= {modelname};Integrated Security=ClaimsToken", "pbiServiceModelId": null, "pbiModelVirtualServerName": "sobe_wowvirtualserver", "pbiModelDatabaseName": "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx", "name": "EntityDataSource", "connectionType": "pbiServiceXmlaStyleLive" } } }Solved909Views0likes4CommentsUpdating Semantic Models api - base64 encoded 'section' values are not json
I've had some success pulling the semantic model via REST api and updating the name inside BUT I would like to update the LineageTags of the fields when I perform a 'clone' operation within my project (my project is a webapp that embeds powerbi). I get the model content which is a list of section keys with base64 encoded values. The issue is that when I decode those values I am not getting json - it's just strangely formatted text. Is there some way to extract it in a different format so that it's easier to manipulate/update? Below is an example of one table's section in the model. Any advice? TIA! table ADR_Level1_2dd5567f-9c5e-4d5d-9608-1b565c2ab830 column ConfigTotal dataType: string sourceProviderType: nvarchar(max) lineageTag: f298b532-ecdc-42ae-985b-298b825130db summarizeBy: none sourceColumn: ConfigTotal annotation SummarizationSetBy = Automatic column L1_CalDec01 dataType: double sourceProviderType: decimal(18, 0) lineageTag: dd5131fd-a7b7-4914-9707-f4f20aa52d2b summarizeBy: none sourceColumn: L1_CalDec01 annotation SummarizationSetBy = Automatic column L1_CalText01 dataType: string sourceProviderType: nvarchar(max) lineageTag: 0df76d62-0309-41a6-bedd-8d1dcadc6eef summarizeBy: none sourceColumn: L1_CalText01 annotation SummarizationSetBy = AutomaticSolved1KViews0likes3CommentsExtending a Semantic Model
Hi, Please help me to understand if this is possible. I have an azure sql db behind a vpn. It works from PBI web portal but it requires the gateway connection so users cannot modify it (I cannot provide them a local connection), HOWEVER, one user group is screaming that they must be able to combine this data with other datasets that they will provide. My understanding is: A report is restricted to use a single semantic model so they can't just use both models. They cannot create a new semantic model which unions my data with their data using the portal because the web portal PowerBI doesn't allow this and they cannot connect from their local pc using PBI Desktop. Any suggestions for me enabling this somehow? It doesn't really seem too crazy, but I didn't realize until now how limited the web portal is.Solved1.1KViews0likes4CommentsWhat is expected behavior for reports after minor schema changes?
I have a schema that is expected to have small changes (ie just column name changes - no types) periodically. I am using the api to update the schema definition when this occurs and that is successful. I thought that as long as I kept the lineage tag the same the report would be fine - but my test report says: "Something's wrong with one or more fields... and lists the OLD name of my schema change as well as ALL the other columns in the table. My only choice is "fix the report" which removes ALL the data from the table and wants me to rebuild it. Isn't this the point of lineage tag? What can I do to avoid ruining all existing reports that reference the column? Just wanted to add that we are embedding PowerBI in a webapp so we are not using the desktop app. Hopefully there's a way to make this work without the desktop app having to republish. Do I need to re-bind the report to the model via the api somehow perhaps?Solved1.2KViews2likes6CommentsPreview Feature - editing semantic model from web - anyone using this?
I really need this feature as we want our users to be able to clone a semantic model that we build programmatically and then add tables/measures/whatever they want to support their needs. The model uses a gateway connection to a private Azure SQL so we cannot don't want to give them the credentials. I just enabled the preview feature for my workspace and I have tried BOTH "add table" and "new measure". Both alternately give: Semantic model out of sync The change you were making failed to apply. We've refreshed the model for you, please try again. or a nastier error that says "contact support", but OCCASIONALLY my changes work. I just created this model - no one is updating it - no clue why it often thinks I'm out of sync. Is anyone using this feature? It appears to have been in preview for a long time - I would expect it to work and be close to general availability by now. Any tips to working around the issues?Solved2.3KViews0likes6Comments
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.