Something cool has just been announced for Azure SQL DB: the ability to call a limited number of REST APIs direct from TSQL. The announcement is here:
Read on for sample code, including a way to execute DAX queries from T-SQL.
Comments closedCategory: Power BI
Chris Webb reminds us that Power BI incremental refresh can lead to some fragmentation:
A lot of people are building large datasets in Power BI Premium nowadays, and if you’re building a large dataset you’re very likely to be using Power BI’s incremental refresh functionality with your fact tables or manually creating and refreshing partitions in them. If so, you should occasionally do a special kind of refresh to shrink the dictionaries on your fact tables.
Read on for a test of the most extreme scenario, though even less extreme versions can be bad.
Comments closedGilbert Quevauvilliers gets the last word:
Power query can be so powerful and once again it came to my rescue.
I had a requirement where I wanted to append some text to the end of each of the column names in my table.
To do this I did the following below.
Click through for the solution.
Comments closedGilbert Quevauvilliers keeps to the schedule:
Below are the steps on how to use Power Automate to schedule a refresh of a Power BI dataset at the time you want it to.
I have recently seen some questions in the Power BI Community with regards to refreshing Power BI datasets. I thought it would be a good idea to blog on how to use Power Automate (Flow) to schedule a refresh of a Power BI Dataset.
Read on to see what the limitation is in Power BI and how you can use Power Automate to get around it.
Comments closedChris Webb doesn’t want to wait:
There are four columns: Date, Town and two measures. One measure called [Fast Measure] is, as the name suggests, very quick to execute; the other measure, called [Slow Measure], is very complex and slow. The definitions are irrelevant here. Notice that there is a filter on this table visual so only the rows where [Fast Measure] is greater than 1 are shown.
If I measure the amount of time to render this table in Performance Analyzer, it takes around 17.5 seconds to run. However, if I remove the filter on [Fast Measure], the table only takes 8 seconds to run. Why? The filter is on the fast measure and surely more rows are returned without the filter, so wouldn’t the slow measure be evaluated more?
Click through for the answer.
Comments closedMara Pereira shows us a trick:
Have you ever wondered if you can apply conditional formatting based on a text field/measure instead of a numeric field/measure?
If your answer is yes, then this trick is for you!
The other day I was working with a customer who asked something that I had no idea how to build.
They wanted to apply conditional formatting over some of their visuals, but they wanted the conditional formatting applied over a text field and not over a numeric field or a measure.
Read on to see how.
Comments closedShabnam Watson noticed something interesting:
While I was tracing some Power BI datasets with Hybrid tables, I noticed that that the DirectQuery partition of a Hybrid table is used in all queries submitted to the Hybrid table, whether or not they are asking for data from that Direct Query partition. On first look, this does not look good because Power BI should be able to use partition pruning for a partitioned table, meaning it should only scan certain partitions. For example, if you ask for historical data from 5 years ago, the current day’s data is not needed to answer that query and hence, the Direct Query partition for today should not be used in the query.
But do read on for more information about what’s going on, as it seems there are layers of nuance here.
Comments closedMarc Lelijveld has a new version of the Power BI Model Documenter:
It is long overdue, but time for a new updated version for the Power BI Model Documenter external tool! The latest release lasts from the first week of 2022 and since then close to 6000 people have downloaded the Model Documenter installer directly from the website, excluding the downloads and clones from the GitHub repository. I can’t share enough how happy I am with all the interactions I’ve had with people from all over the world providing feedback, asking questions and willing to contribute to the Model Documenter.
Read on to see what’s changed since the last release.
Comments closedShabnam Watson troubleshoots an issue:
I was trying to trace a dataset I had published to Power BI service using SQL Server Profiler and I was getting this error:
Either the trace with the ID of ‘MicrosoftProfilerTrace1667261566’ does not exist in the server with the ID of ‘autopremiumhostnorthcentralus001-081’, or the user does not have permissions to access the object.
Read on for the solution.
Comments closedReza Rad explains why the Power BI Service is useful:
The Power BI toolset comes in many shapes and forms. There is a Power BI Desktop, Power BI Mobile app, Power BI Report Server, and Power BI Service (and some other applications and components too). The questions I hear from the new users of Power BI are; Do I need to have an account for Power BI? do I need to use the Power BI website for creating visualization etc.? What is the Power BI website or service, and what is its usage? If I can do the reporting using Power BI Desktop for free, then why would I need the service? In this article and video, I will answer all of that.
Click through for a video or for the article explaining the purpose behind the Power BI Service. Having done work with places using Power BI Report Server and places using the Power BI Service, I will say that the latter takes more work to get corporate-compliant but offers a whole lot more.
Comments closed