A Fine Slice Of SQL Server
Richard Swinbank re-uses a pipeline:
Implementation of one pipeline per report makes additional demands of a developer when creating a new report. To make this easier to manage, in this post I look how to make pipeline creation as simple as possible, by building each pipeline from a set of reusable components.
Click through to see how this works in Azure DevOps. I’d expect the process to be reasonably similar for GitHub Actions as well.
Comments closedMeagan Longoria talks to Oracle:
We needed to make sure we had the most current version of the drivers required to make the package work.
This turned out to be an adventure involving 3 different drivers and plans to refactor, so I’m documenting some of it here in case it helps someone else.
Read on for your options.
Comments closedMarc Lelijveld searches for keys under the lamppost:
Another blog post based on recent client experiences. Last week, I visited a client where we had extensive discussions on data model optimization. As you might know, data modeling in Power BI is one of my favorite topics, so I had an excellent day. It’s also not the first time that I blog about anything data modeling and optimization. If you haven’t read it yet, I recommend reading my previous blog on this topic.
This blog will focus on the need of keys in your tables and primarily your fact tables in your data model. I keep running into data models at customers which are flooded with keys in all tables. For each of them you should ask, do I really need this and could I save it in a different data type for further optimization. In this blog, I will further elaborate on keys in your data model, typical use cases and how these cases can be solved in different manners.
Read the whole thing. The really short version is classic Kimball-style advice: keys for dimensions, not for facts. And in Power BI, removing a unique column from a fact table can speed things up by shrinking the compressed fact table size.
Comments closedOlivier Van Steenlandt doesn’t do things one at a time:
A few weeks ago I released a blog post about migrating SSRS Reports to Power BI Paginated Reports. At that point in time, I wasn’t aware of any way to migrate multiple SSRS Reports in one go.
Meanwhile, I have done some research and experimented a bit. In this blog post, I will be going through 2 different ways to migrate multiple SSRS Reports at once to Power BI.
Click through for Olivier’s findings and how you can migrate en masse.
Comments closedMara Pereira trims off the edges:
If you’ve been following my posts, you probably know by now that one of the things that really annoys me in Power BI is not being able to build bar charts with rounded corners, unless you use a custom visual.
However, recently I found out about a trick to make this happen without needing to use custom visuals (special shout out to Federico Pastor who shared this trick with me!).
Read on to see how you can do this. It’s definitely not ideal, but if you absolutely need rounded corners for your bar chart, you can get them this way.
Comments closedErik Svensen does a wardrobe upgrade:
But I want to see how my new theme might look on some old report where I might have used another theme or perhaps some reports other users have created where they have done some individual formatting instead of using the theme.
And did you know – we can do it and see the result for existing report in your workspaces – and we can directly modify the theme and see if we should change a color or a font size or a….
Read on for the process. This is a clever use of the embedding service, that’s for sure.
Comments closedChris Webb does some ‘splainin’:
One of the most confusing things about troubleshooting Power BI refresh problems is the way Power BI will sometimes try running a refresh again after it has failed. It means that refreshes seem to take a lot longer than you would expect and also that more queries are run against your data source than you would expect. I don’t have all the answers but I thought it would be useful to highlight a few scenarios where it does happen.
Read on for two scenarios in which you might find this.
Comments closedSaira Shaik reserves some instances:
I have created this dashboard to display the savings made due to the purchase of Reservations or Savings Plans or by signing the agreement with Microsoft to get Azure Commitment Discounts (ACD).
This dashboard is helpful for Customers who:
- Purchased Reservations or
- Purchased Savings Plan or
- Signed Monthly Azure Consumption Commitment (MACC) and got a special discounted price.
Customers can view their savings by uploading the Amortized files into this Power BI file.
Click through to se what the dashboard includes and how it all works. Then, check out Saira’s GitHub repo for the template.
Comments closedReza Rad shows off the new visual formatter in Power BI Desktop:
Where is the Format visual option in the new Power BI Desktop? There is a simple answer to this question, which I explained in this blog and video. This change applied from March 2023 version of Power BI Desktop, and by the time you read this article, it might be at general availability and the only way to format a visual in the Power BI Desktop.
I do hope they also keep the old way of formatting visuals, as there appear to be fewer clicks involved.
Comments closedRichard Swinbank deploys a report:
In the first post in this series, I built an Azure DevOps pipeline to automate steps in a Power BI development workflow. The pipeline implemented a very basic workflow – as soon as a developer committed a new report version to Git, the pipeline deployed it immediately into a Power BI workspace.
In this post I’ll be building a pipeline to support a more sophisticated workflow that enables peer review and stakeholder testing.
Click through for the step-by-step process.
Comments closed