Copy Report Layout between two PBIX files

Rui Romano Blog - A place to share my thoughts

This trick was demonstrated in my last session at RADACAD channel: https://youtu.be/xoR-2NjZCCk?t=977

The idea is basically to copy the entire report (pages, filters, bookmarks,…) between two different Power BI Desktop files (.pbix).

Why this is useful? Imagine you are building a new Power BI Report and you need to reuse the entire layout from another report not only the visuals but also the layout, pages, themes, custom visuals,… Yes the dataset will be different and the report visuals will stay in an error state like this:

Yes it seems broken , but the entire layout is there and is easy to change the field of a visual to a new field of the target dataset by drag & drop a new field

To do this you just need to follow these simple steps:

  • Unzip the source and target PBIX files using a tool like 7zip

Copy the Report folder from…

Ursprünglichen Post anzeigen 63 weitere Wörter

Second post in the „Doing Power BI the Right Way“ series. In a business intelligence solution, data must be shaped and transformed. Your data is rarely, if ever, going to be in the right format for analytic reporting. Continue reading →

über Doing Power BI the Right Way: 2. Preparing source data — Paul Turley’s SQL Server BI Blog

Microsot Beta Examen – Es gibt viel zu tun…

Da gibt es einiges zu tun für mich. Klar ist dabei, dass das Vorbereiten auf die Prüfung im Vordergrund steht. So zwinge ich mich selbst am Ball zu bleiben…

https://docs.microsoft.com/en-us/learn/certifications/exams/pl-100

Announcing three new Microsoft Certifications for Business Applications

https://docs.microsoft.com/en-us/learn/certifications/exams/mb-800

 

This is an intro post to the Error Message Mgt. codeunit and related objects. NAV has never brilliant when it comes to error handling, for a couple of reasons. The error messages themselves sometimes leave a lot to be desired The whac-a-mole nature of fixing multiple errors by finding one at a time and attempting […]

über (Slightly) More Elegant Error Handling in Business Central — James Pearson

This is a quick post for giving a response to a question that comes out in our latest Microsoft’s webcast about creating cloud-based workflows for Dynamics 365 Business Central. In this training I’ve talked a lot about the „When an HTTP request is received“ action in Power Automate (and on Azure Logic Apps too) and […]

über Securing your HTTP triggered flow in Power Automate — Stefano Demiliani

Business Central Virtual Event

Konnte gestern etwas in den Event reinschauen:

https://vshow.on24.com/vshow/BCVE/registration/17187

Vor allem hat mich dieser Beitrag interessiert. Ich finde die Integration mittlerweile als sehr gelungen.

Vor allem die Roadmap ist für mich von Interesse. Virtual Entities machen es in der Zukunft möglich, NAV-Daten ins CDS virtuell bereit zu stellen. Es sollen sogar CRUD Operations möglich sein. Das macht für mich vor allem bei der Entwicklung von Hilfstools in PowerApps viel Sinn.

Hier noch ein paar Infos zu aktuellen Stand der Virtual Entities sowie zum Gegenstück in AL:

Create and edit virtual entities that contain data from an external data source

AL Table Proxy Generator

Azure File, Azure Blob and Alibaba Cloud integration in Business Central (with interfaces and telemetry)

Yet another www.business-central.blog

A codeunit to upload files to different containers, implemented with interfaces and monitored with telemetry

SCENARIO

  • The requirement is to replace the reference of „File Management“ codeunit with a new „Azure File Management“ for the SaaS (Cloud) version of Business Central.
  • I want to implement a base „app“ that manages file basic operation on different cloud platforms: upload, download, create folders, copy and move files and folders.
  • I want the app to be reusable by all other app depending on it.
  • I want to monitor the activity with telemetry and application insights.

THE WONDERFUL WORLD OF INTERFACES AND TELEMETRY

This project allows me to use in the real world two of the new powerful and wonderful features of Business Central: interfaces and telemetry. Interfaces are available with a minimum of runtime 5 (you have to kiss goodbye older versions of BC).

AZURE BLOBS VS AZURE FILES

One of the…

Ursprünglichen Post anzeigen 292 weitere Wörter