The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I've got a bit of a peculier problem at the moment.
We are building a template report, like Microsoft does, based on the Log Analytics data from our clients that we collect through LightHouse.
We are converting KQL queries into M-query, loading that into PowerBI using query parameters to switch between our clients' Log Analytics WorkspaceIDs. This uses the Log Analytics API endpoint which means that we have to use import mode.
Sample of one of the queries:
This way we can theoretically have 1 PowerBI template dataset (and report) and publish a client specific version of that template to our clients' PowerBI Service workspace. If we want to change something in that dataset (add a new KPI for instance) then we can edit the template and publish that new version to many different workspaces, all with different query parameters.
The problem is this: We have to have data in the template report to publish it (can't publish a .pbit) and we can only change a query parameter once the dataset is published. We obviously can't set the parameter to our own Log Analytics Workspace first because that would mean publishing a report with our data to our clients' PowerBI Service Workspace (before changing it by changing the parameter).
We have too many clients to edit the parameters by hand in each of the local datasets (one for every client) every time we make an edit so that's not an option.
The only option I can think of is to have a temp BI workspace wherein we publish the template, change the parameter, export the report (with data) back to our DevOps repo, and then publishing that dataset to the specific client's BI workspace but that seems to me to be very inefficient.
Is there a way to publish the dataset to our client's BI workspace with a specific query parameter set, or is there a way to automate changing the query parameter in a pbix file in our DevOps repo, or is there an option of publishing the template without data having been loaded in (the structure of the dataset without Log Analytics data being loaded in through the API)?