(Credits to ChatGPT for writing most of this blog post ? ) to sign up and dive into the conversations happening right now. We can’t wait for you to be a part of this vibrant, collaborative community! , …) and when it comes to interactive collaboration, I think Slack is much more efficient in getting answers to your immediate questions than traditional forums etc. Here are some other reasons why I think that’s the case ..read more

As this is an open-source project, you can also contribute directly by creating pull requests. If you like the extension and make sure I don’t run out of coffee while continuously improving it you can also for me to contribute to this extension. is enabled for read/write mode, you can select “Edit TMDL” from the context menu of your dataset. This will add a new folder to your VSCode workspace that represents the TMDL structure of that dataset. You can now navigate the individual files, change them and validate them. once you are happy with the changes, you can also publish your changes back to ..read more

This technique can also be applied to any other APIs that expose data. The most challenging part is usually the authentication but Fabric’s make it pretty easy for us to do this. with the results and then returns them as a list of items. Please check e.g. the call to better understand the structure of the result. The function further adds a new property to each item to make nesting of API calls easier as you will see in the final example. The following code exposes it to PySpark and also Spark SQL ..read more

The .pbix file can be downloaded here: Ideally you could even use the USERCULTURE() DAX function but unfortunately this is currently not supported in the PBI service. There is already an open for which you can vote if this is important to you. Chris Webb’s blog post on Implementing Data (As Well As Metadata) Translations In Power BI – a must-read if you need to deal with translations in Power BI. Another good read on the topic is the blog post Multilingual Reports in Power BI from PBI Guy give us a bit more flexibility here and another potential solution to implement data and value translation ..read more

As I said, I do not know if this is a new feature (or a feature at all), but it is definitely helpful for certain scenarios. Even though this looks quite trivial, there are some caveats which makes me believe this is not fully supported yet. You may noticed above already that in Power Query, when going to the step that actually queries the database, it complains about that this step would cause the whole table to be converted to Import Mode. However, you can just it and go on with the next step to ..read more

In a follow-up post I will explain the technical details and what actually happens in the background when you use a setup like this so stay tuned! is any approach to data management that allows an application to retrieve and manipulate data without requiring technical details about the data, such as how it is formatted at source, or where it is physically located, and can provide a (or single view of any other entity) of the overall data.” The problem is that in reality the things are not as simple as they may sound, especially when it comes to joining across the different sources. While data ..read more

The final PBIX workbook can also be downloaded: 1) create a new table in the data model (either with Power Query or DAX) that contains all our items that we want to use in our TopN calculation and an additional row for “Others” 2) link the new table also to the fact table, similar to the original table that contains your items 4) use the new measure in combination with the new table/column in your visual 3) write a measure that calculates the rank for each item, filters the TopN items and assigns the rest to the “Others” item ..read more

– use Power Query to pre-aggregate the data if possible ) in the comments is the fact, that this approach can cause serious performance problems at the data source and also on the Power BI side. So in this post we will have a closer look on what actually happens in the background and which queries are executed when you join different data sources on-the-fly. So I think that Power BI is still a viable solution for data virtualization if you keep the following things in mind: – keep the items in the join columns at a minimum – don’t expect too much in terms of performance – only use it when you ..read more

I did some further thinking and this approach could probably also be used to mimic custom roll-ups and unary operators we know from Analysis Services Multidimensional cubes. If I find some proper examples and this turns out to be feasibly I will write another blog post about it! Depending on your final report layout, you may not need all of them and you should consider removing those that are not needed! returns the selected value if only one item is in the current filter context and This could also be fixed in the DAX measure by checking how many rows are actually selected for each level and ..read more

In addition, these new cmdlets can also be used in your Continuous Integration/Continuous Delivery (CI/CD) pipelines in Azure DevOps or any other CI/CD tool! Having those scripts made the whole migration a very easy task. the latest version from the PowerShell gallery and give it a try! So I basically extended the module and added new Import and Export functions which automatically process all the different content types ..read more