christian9596vor 5 Tagen1 Min.Page limits for email subscriptions in Power BI PremiumIn this blog post we outline specifics about the 20 page limit for Power BI email subscriptions in a Premium workspace.
Brunner_BIvor 7 Tagen1 Min.Finding errors in Dataflows or PowerQueryThis article outlines how you can find errors quickly in Dataflows or PowerQuery using a small M script.
christian959624. Juni2 Min.How to open .ods files in Power BI / Power QueryThis blog post shows how to import .ods files on the web natively into Power Query / Power BI.
Brunner_BI13. Mai2 Min.How to disable the automatic refresh of a dataset after upload to the Power BI ServiceThis blog post illustrates how to disable the automatic refresh in the Power BI service when uploading a dataset.
Brunner_BI13. Apr.2 Min.Format strings for calculation groups in live reportsWhen building a live report on a dataset with a calculation group, format strings might not work as expected. We found a solution for this.
Brunner_BI5. Apr.1 Min.Exporting data from Power BI Desktop without limitsIf you want to export more than 30k or 150k rows, this blog post will help you get around the internal limits in Power BI.
Brunner_BI29. Jan.1 Min.New ways to check if queries fold in Power QueryThis article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not
Brunner_BI30. Dez. 20212 Min.Allocating amounts using lists in Power QueryWe will show you how to create dates between a start and an end date using the list operator in Power Query. This can be handy as well for a
Brunner_BI18. Dez. 20212 Min.Extending calculation groups in Power BI with unstructured data (targets, budgets etc.)Calculation groups in Power BI a lot of times rely on time intelligence calculations. If you do not know calculation groups yet, read...
Brunner_BI14. Dez. 20211 Min.Dataflows gets around the 3,000 cell enter data limit in Power BIThis blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop
martin111930. Sept. 20212 Min.Time saving scripts in Tabular EditorHow to format all dax measures in one click. How to add descriptions to your measures using Tabular Editor. Good for live reports especially
Brunner_BI4. Sept. 20217 Min.How I use Azure VMs for Power BI developmentFor once this is not a technical blog about a feature or trick in Microsoft Power BI. In this blog post, I want to explain the benefits...
Brunner_BI10. Juli 20213 Min.How to visualize any map in Power BIUntil a few months ago, I have only worked with either Bing maps, filled maps or shape maps (these are the standard visuals in Power BI)....
Brunner_BI3. Juli 20213 Min.Dynamic pop-up or warning images in Power BIFor me, Power BI has become a rather complete tool over the last few years. Some things are still missing though, like pop-up messages....
Brunner_BI5. Juni 20211 Min.Dynamic tooltip pages in Microsoft Power BI for measures as columnsThis post explains how you can make your tooltip pages in MS Power BI completely dynamic to show different measures.
Brunner_BI24. Apr. 20211 Min.Trigger instant refreshs of Power BI Datasets with Power AutomateAutomatically trigger a refresh for a Power BI Dataset when a Dataflow refresh completes. This can be achieved easily using PowerApps.
Brunner_BI27. März 20213 Min.Fixing Delta % once and for allHow do you correctly calculate a Delta % YTD or just a percentage change of two values? Check out my Power BI Blog post for a DAX solution
Brunner_BI10. Jan. 20211 Min.How to fix duration data types in Power BI DataflowsPower BI Dataflows are still pretty new to most. I think it is amazing that Power Query has moved to the cloud and you can use it with a...
Brunner_BI9. Jan. 20211 Min.How to force users to select a filter in Power BI while keeping the report interactiveOne of our clients recently asked us to find a better solution for forcing users to select a filter value. They had this: The first...
Brunner_BI29. Dez. 20201 Min.How to avoid having to use a personal gateway for web data sources (html page or table) in Power BIWhen you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...