Azure DevOps pipeline to replicate Power BI report changes for various repositories (PBI workspaces)
Hello, here is my business request: -> we are having data from various countries and would like to have dedicated Power BI workspace for data from each country -> it will help us with permissions management, will clearly separate the data,... And technical setup so far looks as the following: -> as semantic models will have the same schema (table names, metric names), it means, that semantic models within each workspace will be using slightly different SQL query (which will gather data for the respective country) -> it's true, that maintenance of semantic models for multiple workspaces may be then be a little bit longer (as we will have to adapt changes for each workspace), but changes for semantic models are not frequent and usually we do bulk of changes together But I am now dealing with the technical question and what would be the best practice for development of Power BI reports, where we would like to reduce amount of duplicated work. Below is my idea for technical implementation: -> PBI reports are developed for one workspace within Azure DevOps repository, then merged through Pull request and then published into PBI workspace through Source control integration in PBI -> and I would like to have Azure pipeline, which will listen to the Pull request merge (basically any change in the master branch of that repository) and then will create similar Pull request in another repository (which is linked to another Power BI workspace), while replicating all the adapted changes for reports -> as was mentioned, schema of semantic models is the same between workspace, so it's only important for replication of Pull request with changed reports to keep proper connection (from Power BI report to semantic model), everything else can be simply copied => and my question really is, if you think, that this could be the right approach (having Azure pipelines to replicated PBI report changes into multiple repositories) and if yes, whether you could suggest to me some working Azure DevOps YAML pipelines examples ? many thanks in advance for any thoughts or suggestions
Export data brings empty when filtered by a "user context" type column
There is a report with en-GB and tr-TR language selection A calculated column in the fact table that has this formula below. Of course i must be selected "User Context" value in Expression context field of this column. Hat lang = var _lang = LEFT(USERCULTURE(),2) return SWITCH(TRUE() , _lang = "tr" , 'Hammadde'[Hat] , _lang = "en" , SUBSTITUTE('Hammadde'[Hat], "HAT", "LINE") ) A slicer in the page that has a Hat lang column inside. Default language of my browser is EN. In service (in published report) if i select LINE1 in En version (url has &language=en-GB at the end) of report it fulfills the table, and export data option works well. But if i change language by adding "&language=tr-TR" to the end of URL and select HAT1 in slicer, the table fullfills just the same as before but export data option exports an empty excel file.
Automating Auto Date/Time Configuration in Fabric Semantic Models
How can one use an explicit enterprise Date table and to avoid Auto date/time in shared semantic models within Microsoft Fabric, without requiring developers to manually disable the Auto date/time feature in Power BI Desktop? The goal is to reduce unnecessary date/time tables and semantic model size while ensuring all date-related filtering and time intelligence use the central enterprise Date table. Is there a supported way to enforce or automate this configuration?
Date.From(datetimezone) returns different results when using On-Premises Gateway
Hi all, I found what appears to be a date conversion inconsistency in Power BI Dataflow Gen1 when an On-Premises Data Gateway is used. Power BI Dataflow Gen1 Power BI Service Same workspace Same dataflow Comparison : Without gateway & With on-premises gateway let UTC = DateTimeZone.UtcNow(), JST = UTC + #duration(0,9,0,0), Date1 = Date.From(JST), Date2 = Date.From(DateTimeZone.RemoveZone(JST)) in #table( {"UTC","JST","Date1","Date2"}, {{UTC,JST,Date1,Date2}} ) Expected Result：Both Date1 and Date2 should return the same date because they represent the same instant. Date1 = 2026-08-31 Date2 = 2026-08-31 Actual Result： Without gateway: Date1 = 2026-08-31 Date2 = 2026-08-31 With gateway: Date1 = 2026-09-01 Date2 = 2026-08-31
this error seems to interfere with version control and deploy pipelines
I'm not sure why we built our pipelines under fabric instead of vanilla pbi, but it seems to us that changes in the ws's tied to pipelines cause this error to show (sometimes) when we are trying to make wor space settings relatyed to pipelines and version control. the error seems to disappear (we think) a day later too. does anybody know what this is all about?
Using a semantic model
I am creating my own dashboard where i reference not only my data, but data i am getting from a different semantic model. When I go to publish my dashboard, i am getting an error message on the charts/graphics that reference the other model's semantic model. any ideas on how to fix this? I have all of the necessary build permissions on the other semantic model, and both dashboards are in the same workspace
PowerBI app wont show new report
Hey, I am trying to add a report from my workspace to my app. When i publish it wont appear. It says that that the report is included in the app, but it doesnt appear. I have tried: 1. refreshing and clearing cache 2. deleting entire report + dataset and reuploading 3. checked audiences / visibility 4. checked if my colleague could do it Nothing works. I have also tried with other files that werent in the app before, and i cant get them to show up either. When i hide an existing report, that will dissappear, and i can also get i to reappear, but i cant seem to get any new reports up and running. I have added some pictures for reference. Report and dataset: Content: Audience: App: I dont know what to do.Staging LH & WH expired credentials
Hi, Account A created a DFgen 2, as you know these come with hidden staging LH and WH. Account B took over the dataflow and destination warehouse (gold WH). Account A has since been archived. All worked for almost 60 days, but dataflows are failing. Disabling the staging features in the dataflow allowed account B to run one particular dataflow, however for the other DF that pushes into warehouse, staging cannot be deleted. Reading the mashup error message clearly states that tokens for account A have expired, and also provides the id of staging LH and WH. How can I now take over and own these HIDDEN LH and WH with account B so that the DFsG2 stops failing? Is there a way we could have prevented this - assuming account A would have still created the intiail DFs -. Thanks,PowerBI Server cannot set scheduled refresh
I started to realize yesterday that I couldn't set up scheduled refresh for semantic models published to the server, and this problem still exists today I have checked the credentials and connection of the data source, and there is no need for a gateway. Moreover, I am the admin of the workspace, so there is no situation of insufficient permissions. After testing, another report with a small amount of data cannot be set to refresh on a scheduled basis. However, I can successfully refresh it manually, so I am more suspicious that the information from the server frontend cannot be synchronized to the backend for saving. When can this problem be fixed
