Apr 13, 2020 · [Update September 2023: now that Power BI is part of Microsoft Fabric, the new features of Fabric make it much easier to solve this problem as described here]. Power BI incremental refresh is a very powerful feature and now it’s available in Shared capacity (not just Premium) everyone can use it. It’s designed for scenarios where you have a data warehouse running on a relational database ...

Aug 29, 2021 · “In particular, hard-coding usernames/passwords or client ids/client secrets in your M code is a really bad idea” @Chris – Do you know a way in which a Excel File containing a M query pulling data from a lets say an Access Database can be shared with the end user – without them having to enter a database password first time they open it on their system

Nov 21, 2022 · A quick thank you Chris… I’m below the beginner level when it comes to all things data and have been making very very ineffecient data sets using power query and power pivot (just downloaded power bi desktop.)

Dec 5, 2021 · There is also an oauth2 tocken timeout problem after an hour. This seems to impact pq running on gateway, but not on pbi desktop. This appears to be a well-known bug that Msft won’t fix.

Jun 7, 2020 · Found the answer myself. To only expand a selected column from the second table using a Table.Join, the easiest is to pre-prepare the second table before the merge operation, i.e. a sub-select on the second table as below

Dec 1, 2024 · Fabric’s Real-Time Intelligence features are, for me, the most interesting things to learn about in the platform. I’m not going to pretend to be an expert in them – far from it – but they are quite easy to use and they open up some interesting …

Nov 10, 2024 · Continuing my occasional series of ways you can improve the results you get from Power BI Copilot by setting properties on your semantic model, in this post I’ll look at how setting the Summarize By property can have an impact.

May 15, 2024 · Since the announcement in March that Power BI Premium P-SKUs are being retired and that customers will need to migrate to F-SKU capacities intead I have been asked the same question several times:. Why are you forcing me to migrate to Fabric??? This thread on Reddit is a great example. What I want to make clear in this post is the following: Moving from P-SKU capacities to F-SKU capacities is ...

Dec 8, 2024 · For me the biggest new feature in the January 2025 release of Power BI Desktop is the new TMDL View; many other people like Marco are excited about it too. For more advanced Power BI developers (and honestly, I don’t think you need to be that advanced to get value out of it) it makes certain editing tasks for semantic models much simpler, and while I won’t be abandoning the main Power BI ...

Oct 13, 2024 · I concur with your thoughts. with advancements in genai models and power bi moving towards it (gpt4 to gpt4o) plus letting users to train how the copilot should answer from their semantic model (like that in AI skills), soon copilot in pbi will do a much much better job and the c-suite who wants answers in chatty format will …