Searching a Power BI report's M code with a few clicks
We show how you can easily search a Power BI semantic model's M code in just a few clicks using an external tool.
top of page
Suche
Brunner_BI
28. Juni2 Min. Lesezeit
Integrating Jira with Power BI
In this blog post we can see how we can easily connect Power BI to the Jira REST API to retrieve data.
44 Ansichten0 Kommentare
Brunner_BI
21. Juni2 Min. Lesezeit
Query folding and data types from Snowflake in Power BI
When working with decimals and integers from Snowflake in Power Query, you need to watch out for data type conversion.
42 Ansichten0 Kommentare
Brunner_BI
19. Nov. 20223 Min. Lesezeit
Removing unused columns and measures in Power BI
How to remove unused columns and measures using Power BI external tool Measure Killer
322 Ansichten0 Kommentare
Brunner_BI
27. Juni 20221 Min. Lesezeit
Finding errors in Dataflows or PowerQuery
This article outlines how you can find errors quickly in Dataflows or PowerQuery using a small M script.
706 Ansichten0 Kommentare
christian9596
24. Juni 20222 Min. Lesezeit
How to open .ods files in Power BI / Power Query
This blog post shows how to import .ods files on the web natively into Power Query / Power BI.
1.189 Ansichten1 Kommentar
Brunner_BI
29. Jan. 20221 Min. Lesezeit
New ways to check if queries fold in Power Query
This article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not
966 Ansichten0 Kommentare
Brunner_BI
30. Dez. 20212 Min. Lesezeit
Allocating amounts using lists in Power Query
We 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
127 Ansichten1 Kommentar
Brunner_BI
14. Dez. 20211 Min. Lesezeit
Dataflows gets around the 3,000 cell enter data limit in Power BI
This blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop
391 Ansichten0 Kommentare
Brunner_BI
29. Dez. 20201 Min. Lesezeit
How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI
When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...
3.018 Ansichten8 Kommentare
Brunner_BI
17. Dez. 20201 Min. Lesezeit
Changing data types that do not break query-folding in Power Query / Power BI
There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source
2.010 Ansichten0 Kommentare
Brunner_BI
15. Dez. 20201 Min. Lesezeit
Creating a custom fiscal calendar in Power BI
Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.
1.112 Ansichten0 Kommentare
bottom of page