Are you over 18 and want to see adult content?
More Annotations
Librería virtual: Compre aquí libros académicos, universitarios y técnicos - Lemoine Editores
Are you over 18 and want to see adult content?
Caracol Televisión, entretenimiento y programación - Caracol TV
Are you over 18 and want to see adult content?
SAIMM - The Southern African Institute of Mining and Metallurgy
Are you over 18 and want to see adult content?
BillEz | Salon Software | Spa Software | Hair Salon Software
Are you over 18 and want to see adult content?
Teléfono Gratuito de Atención al Cliente | No más 900
Are you over 18 and want to see adult content?
WordPress.com — Get a Free Blog Here
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of zidanduanxin.com
Are you over 18 and want to see adult content?
A complete backup of steam-friends.info
Are you over 18 and want to see adult content?
A complete backup of thebottomlinecpa.com
Are you over 18 and want to see adult content?
A complete backup of senthilvayal.com
Are you over 18 and want to see adult content?
A complete backup of imaginespa.co.uk
Are you over 18 and want to see adult content?
Text
Query it can
CHRIS WEBB'S BI BLOG: SSASDIAG: A TOOL TO HELP DIAGNOSE There are a lot of great community-developed tools out there for Analysis Services developers to use (BI Developer Extensions, DAX Studio, Tabular Editor, Analysis Services Query Analyzer to name a few) and they have saved me vast amounts of time and effort over the years. When I joined Microsoft last month I came across one CHRIS WEBB'S BI BLOG: POWER BI REPORT BUILDER AND If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built from the Adventure Works Tabular demo database, with one measure and one parameter built Calendar Year: Note that the “Enable Multi Value Parameters” option CHRIS WEBB'S BI BLOG: ODBC DATA SOURCES, THE A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh and of the Power Query Editor’s previewpane.
CHRIS WEBB'S BI BLOG CHRIS WEBB'S BI BLOGDATA VISUALISATIONEVENTSBUSINESSSANDDANCESECURITYMASTER DATA SERVICES In summary there will soon be a lightweight, web-based version of Visio available to anyone with a Microsoft 365 Business, Office 365 E1/E3/E5, F3, A1, A3 or A5 subscription. Previously Visio was not part of the main M365 plans and was only available as a separate purchase. So what? As a Power BI CHRIS WEBB'S BI BLOG: QUERY FOLDING ON SQL QUERIES IN Of course this doesn’t mean that everything can be folded now, but it’s nice to see that some folding on native SQL queries is now possible.. As I said this only works for SQL Server and Postgres at the time of writing and there is one other limitation: folding won’t happen if you’re passing parameters back to your SQL query in the way I describe here. CHRIS WEBB'S BI BLOG: IMPROVING THE PERFORMANCE OF So far in this series of posts looking at the performance of importing data from files stored in ADLSgen2 into Power BI I have looked at trying to tune refresh by changing various options in the Power Query engine or by changing the file format used. However there is one very important optimisation in the CHRIS WEBB'S BI BLOG: PARQUET FILE PERFORMANCE IN POWER BI There has been a lot of excitement around the newly-added support for reading from Parquet files in Power BI. However I have to admit that I was disappointed not to see any big improvements in performance when reading data from Parquet compared to reading data from CSV (for example, see here) when I first started CHRIS WEBB'S BI BLOG: TESTING THE PERFORMANCE IMPACT OF Continuing my series on tuning the performance of importing data from ADLSgen2 into Power BI, in this post I'm going to look at the performance impact of setting some of the various options in the second parameter of the AzureStorage.DataLake() M function. In the last post in this series I showed how setting the HierarchicalNavigation CHRIS WEBB'S BI BLOG: THE PROS AND CONS OF MODELLING You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’ll have two main types of column: dimension keys, which link the fact table to dimension tables, and measures, which store the data you want to aggregate and analyse. CHRIS WEBB'S BI BLOG: UNDERSTANDING THE “THE KEY DIDN’T One of the most common errors you'll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn't match any rows in the table It can occur with almost any data source and in a wide variety of different circumstances, and for new users of PowerQuery it can
CHRIS WEBB'S BI BLOG: SSASDIAG: A TOOL TO HELP DIAGNOSE There are a lot of great community-developed tools out there for Analysis Services developers to use (BI Developer Extensions, DAX Studio, Tabular Editor, Analysis Services Query Analyzer to name a few) and they have saved me vast amounts of time and effort over the years. When I joined Microsoft last month I came across one CHRIS WEBB'S BI BLOG: POWER BI REPORT BUILDER AND If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built from the Adventure Works Tabular demo database, with one measure and one parameter built Calendar Year: Note that the “Enable Multi Value Parameters” option CHRIS WEBB'S BI BLOG: ODBC DATA SOURCES, THE A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh and of the Power Query Editor’s previewpane.
CHRIS WEBB'S BI BLOG: SPEED UP POWER QUERY IN POWER BI A really useful new Power Query performance enhancement was added to Power BI Desktop in an update to the May release via the Microsoft Store a week or so ago (if you’re not installing Power BI Desktop through the Microsoft Store you’ll have to CHRIS WEBB'S BI BLOG: FIVE MISTAKES TO AVOID WHEN Now that Power BI is so popular, it's becoming more and more common for organisations to migrate their reports from other BI platforms to Power BI. And why not? You'll be moving to a modern, industry-leading, cloud-native BI platform and probably saving a lot of money in licensing costs too. As a Microsoft employee I CHRIS WEBB'S BI BLOG: ODBC DATA SOURCES, THE A few weeks ago I received a great tip from Simon Nuss about a Power Query feature relating to ODBC data sources that I hadn’t seen before (although it’s in Power BI Desktop and Excel 365, so it can’t be that new) and which is potentially important for the performance of data refresh and of the Power Query Editor’s previewpane.
CHRIS WEBB'S BI BLOG: UNDERSTANDING LET EXPRESSIONS IN M The value that the let expression returns is given in the in clause. In this example the in clause returns the value of the variable step3, which is 21.. It’s important to understand that the in clause can reference any or none of the variables in the variable list. It’s also important to understand that, while the variable list might look like procedural code it isn’t, it’s just a CHRIS WEBB'S BI BLOG CHRIS WEBB'S BI BLOG In part 1 of this series I showed how you can use Profiler to find out which MDX calculations are being evaluated when a query runs on SSAS Multidimensional. In this post I’ll show a practical example of why this is so useful: a situation where SSAS evaluates a CHRIS WEBB'S BI BLOG CHRIS WEBB'S BI BLOG Call this query Date and then load it to a table on a worksheet. Once you’ve done that you can create Excel slicers on that table (slicers can be created on tables as well as PivotTables in Excel 2013 but not in Excel 2010) by clicking inside it and then CHRIS WEBB'S BI BLOG CHRIS WEBB'S BI BLOG The other day, while I was reading this post by Melissa Coates, I was reminded of the existence of extended events in SSAS.I say ‘reminded’ because although this is a subject I’ve blogged about before, I have never done anything serious with extended events because you can get the same data from Profiler much more easily, so I had pretty much forgotten about them. CHRIS WEBB'S BI BLOG: ANALYSIS SERVICES CHRIS WEBB'S BI BLOG One of the questions discussed in the book that Marco, Alberto and I wrote last year, “Expert Cube Development with SSAS 2008” (available in all good bookshops, folks!) was whether, if you have multiple fact tables, you should create one big cube with multiple measure groups or multiple cubes each with a single measure group. While I still stand by what we wrote then, I recently took part CHRIS WEBB'S BI BLOG: ANALYSIS SERVICES CHRIS WEBB'S BI BLOG Now here’s the fun bit. I then deployed and processed the cube, closed BIDS and went to SQL Management Studio. There I scripted the Internet Sales Facts linked measure group in ‘EventsInProgress2’ to an XMLA Create statement, then manually updated the XMLA by adding a 1 to the end of the name and ID of the object itself and the Line Item Count measure, then executed the script CHRIS WEBB CHRIS WEBB'S BI BLOG This subject came up in a recent thread I was involved in on microsoft.public.sqlserver.olap, and in my experience poorly-performing queries using YTD-style calculations are a common problem. When you think about it the reason why is fairly clear: retrieving and then summing up up to 12 months of data is always going to take longer than retrieving one month of data alone, especially ifthe
CHRIS WEBB'S BI BLOG CHRIS WEBB'S BI BLOGDATA VISUALISATIONEVENTSBUSINESSSANDDANCESECURITYMASTER DATA SERVICES A really useful new Power Query performance enhancement was added to Power BI Desktop in an update to the May release via the Microsoft Store a week or so ago (if you’re not installing Power BI Desktop through the Microsoft Store you’ll have to CHRIS WEBB'S BI BLOG: QUERY FOLDING ON SQL QUERIES IN Of course this doesn’t mean that everything can be folded now, but it’s nice to see that some folding on native SQL queries is now possible.. As I said this only works for SQL Server and Postgres at the time of writing and there is one other limitation: folding won’t happen if you’re passing parameters back to your SQL query in the way I describe here. CHRIS WEBB'S BI BLOG: IMPROVING THE PERFORMANCE OF So far in this series of posts looking at the performance of importing data from files stored in ADLSgen2 into Power BI I have looked at trying to tune refresh by changing various options in the Power Query engine or by changing the file format used. However there is one very important optimisation in the CHRIS WEBB'S BI BLOG: THE PROS AND CONS OF MODELLING You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’ll have two main types of column: dimension keys, which link the fact table to dimension tables, and measures, which store the data you want to aggregate and analyse. CHRIS WEBB'S BI BLOG: OPTIMISING THE PERFORMANCE OF POWER The SortMerge algorithm, last in the list above, is the focus of this blog post. I mentioned in my earlier posts that the reason that merge operations on non-foldable data sources are often slow is that both of the tables used in the merge need to be held in memory. CHRIS WEBB'S BI BLOG: UNDERSTANDING THE “THE KEY DIDN’T One of the most common errors you'll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn't match any rows in the table It can occur with almost any data source and in a wide variety of different circumstances, and for new users of PowerQuery it can
CHRIS WEBB'S BI BLOG: POWER BI REPORT BUILDER AND If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built from the Adventure Works Tabular demo database, with one measure and one parameter built Calendar Year: Note that the “Enable Multi Value Parameters” option CHRIS WEBB'S BI BLOG: UNDERSTANDING LET EXPRESSIONS IN M The value that the let expression returns is given in the in clause. In this example the in clause returns the value of the variable step3, which is 21.. It’s important to understand that the in clause can reference any or none of the variables in the variable list. It’s also important to understand that, while the variable list might look like procedural code it isn’t, it’s just a CHRIS WEBB'S BI BLOG: WHAT IS THE MAXIMUM LENGTH OF A TEXT What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can load into a single cell in a table in a dataset is 32766 characters – any more than that and the text will be silently truncated. CHRIS WEBB'S BI BLOG: GENERATING REPORTS USING WORD The new “Populate a Microsoft Word template” action in Flow that was released last week got me thinking: apart from the obvious mail-merge applications, this could be used to build reports in Word! Here’s a very simple example. Let’s say you have a table in an Excel worksheet stored in OneDrive for Business: Let’s say CHRIS WEBB'S BI BLOG CHRIS WEBB'S BI BLOGDATA VISUALISATIONEVENTSBUSINESSSANDDANCESECURITYMASTER DATA SERVICES A really useful new Power Query performance enhancement was added to Power BI Desktop in an update to the May release via the Microsoft Store a week or so ago (if you’re not installing Power BI Desktop through the Microsoft Store you’ll have to CHRIS WEBB'S BI BLOG: QUERY FOLDING ON SQL QUERIES IN Of course this doesn’t mean that everything can be folded now, but it’s nice to see that some folding on native SQL queries is now possible.. As I said this only works for SQL Server and Postgres at the time of writing and there is one other limitation: folding won’t happen if you’re passing parameters back to your SQL query in the way I describe here. CHRIS WEBB'S BI BLOG: IMPROVING THE PERFORMANCE OF So far in this series of posts looking at the performance of importing data from files stored in ADLSgen2 into Power BI I have looked at trying to tune refresh by changing various options in the Power Query engine or by changing the file format used. However there is one very important optimisation in the CHRIS WEBB'S BI BLOG: THE PROS AND CONS OF MODELLING You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’ll have two main types of column: dimension keys, which link the fact table to dimension tables, and measures, which store the data you want to aggregate and analyse. CHRIS WEBB'S BI BLOG: OPTIMISING THE PERFORMANCE OF POWER The SortMerge algorithm, last in the list above, is the focus of this blog post. I mentioned in my earlier posts that the reason that merge operations on non-foldable data sources are often slow is that both of the tables used in the merge need to be held in memory. CHRIS WEBB'S BI BLOG: UNDERSTANDING THE “THE KEY DIDN’T One of the most common errors you'll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn't match any rows in the table It can occur with almost any data source and in a wide variety of different circumstances, and for new users of PowerQuery it can
CHRIS WEBB'S BI BLOG: POWER BI REPORT BUILDER AND If you’re building DAX queries using Power BI Report Builder you might notice something that looks like a new DAX function called RSCustomDaxFilter. For example, here’s a simple DAX query built from the Adventure Works Tabular demo database, with one measure and one parameter built Calendar Year: Note that the “Enable Multi Value Parameters” option CHRIS WEBB'S BI BLOG: UNDERSTANDING LET EXPRESSIONS IN M The value that the let expression returns is given in the in clause. In this example the in clause returns the value of the variable step3, which is 21.. It’s important to understand that the in clause can reference any or none of the variables in the variable list. It’s also important to understand that, while the variable list might look like procedural code it isn’t, it’s just a CHRIS WEBB'S BI BLOG: WHAT IS THE MAXIMUM LENGTH OF A TEXT What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can load into a single cell in a table in a dataset is 32766 characters – any more than that and the text will be silently truncated. CHRIS WEBB'S BI BLOG: GENERATING REPORTS USING WORD The new “Populate a Microsoft Word template” action in Flow that was released last week got me thinking: apart from the obvious mail-merge applications, this could be used to build reports in Word! Here’s a very simple example. Let’s say you have a table in an Excel worksheet stored in OneDrive for Business: Let’s say CHRIS WEBB'S BI BLOG: WHAT THE NEW VISIO WEB APP AND In summary there will soon be a lightweight, web-based version of Visio available to anyone with a Microsoft 365 Business, Office 365 E1/E3/E5, F3, A1, A3 or A5 subscription. Previously Visio was not part of the main M365 plans and was only available as a separate purchase. So what? As a Power BI CHRIS WEBB'S BI BLOG: SPEED UP POWER QUERY IN POWER BI A really useful new Power Query performance enhancement was added to Power BI Desktop in an update to the May release via the Microsoft Store a week or so ago (if you’re not installing Power BI Desktop through the Microsoft Store you’ll have to CHRIS WEBB'S BI BLOG: POWER BI DATAFLOW PERFORMANCE For a full explanation of when the Enhanced Compute Engine can and can’t be used see Matthew Roche’s blog post here; basically it loads data into a SQL-based cache which Computed Tables can then leverage which means that data access is faster and the Power Query engine can push transformations back to it via query folding.The only other change I made was to set data types on the CHRIS WEBB'S BI BLOG: PARQUET FILE PERFORMANCE IN POWER BI There has been a lot of excitement around the newly-added support for reading from Parquet files in Power BI. However I have to admit that I was disappointed not to see any big improvements in performance when reading data from Parquet compared to reading data from CSV (for example, see here) when I first started CHRIS WEBB'S BI BLOG: COMPARING THE PERFORMANCE OF Since I started this long and rambling series of posts on importing data from ADLSgen2 into Power BI a lot of people have asked me the same question: will using Parquet files instead of CSV files perform better? In this post you'll find out. To test the performance of Parquet files I took the data CHRIS WEBB'S BI BLOG: OPTIMISING THE PERFORMANCE OF POWER The SortMerge algorithm, last in the list above, is the focus of this blog post. I mentioned in my earlier posts that the reason that merge operations on non-foldable data sources are often slow is that both of the tables used in the merge need to be held in memory. CHRIS WEBB'S BI BLOG: LIMIT THE AMOUNT OF DATA YOU WORK If you're working with large amounts of data in Power BI you may find that you have problems because: Your pbix file is very large You spend a long time waiting for refreshes to finish in Power BI Desktop - and if you're developing, you may need to refresh your dataset frequentlyIt takes a
CHRIS WEBB'S BI BLOG: TESTING THE PERFORMANCE IMPACT OF Continuing my series on tuning the performance of importing data from ADLSgen2 into Power BI, in this post I'm going to look at the performance impact of setting some of the various options in the second parameter of the AzureStorage.DataLake() M function. In the last post in this series I showed how setting the HierarchicalNavigation CHRIS WEBB'S BI BLOG: DYNAMICALLY GENERATED LINES ON A MAP I don’t generally blog about data visualisation in Power BI because it’s not my strong point, and I don’t blog about maps and geospatial analysis because I know even less about that subject and there are people like David Eldersveld who cover it so well. I do like playing around with maps though and recently I’ve been having fun with the Icon Map custom visual developed by James Dales. CHRIS WEBB'S BI BLOG: EXCEL DYNAMIC ARRAYS AND THE CUBESET Among all the exciting announcements made at Ignite last week, one you may have missed (even in all the Excel-related announcements here) was that dynamic arrays have finally reached GA. Ever since they were announced I’ve been interested in how they can be used with Excel cube functions, which allow you to get data from Analysis Services, Power BI and the Excel Data Model/Power Pivot intoWEB HOSTING SERVER
You've hit the default page for this shared hosting server. If you need assistance accessing your website, please contact us and our friendly UK-based support team will help you out in no time.Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0