Exploring Automatic Partition Maintenance in Power BI datasets with Incremental Refresh, using EffectiveDate parameter

During one of my presentations on Incremental Refresh (IR) in Power BI, someone asked what happens during a Power BI automatic partition maintenance window when Power BI has an opportunity to merge smaller partitions into larger ones. Does Power BI use the data that is already imported into Power BI for the smaller partitions and … Continue reading Exploring Automatic Partition Maintenance in Power BI datasets with Incremental Refresh, using EffectiveDate parameter

How does the DirectQuery partition of a Hybrid table in Power BI get used in queries?

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 … Continue reading How does the DirectQuery partition of a Hybrid table in Power BI get used in queries?

Error running a SQL Server Profiler trace for a Power BI dataset: Either the trace with the ID of ‘MicrosoftProfilerTrace1667261566’ does not exist …

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. For … Continue reading Error running a SQL Server Profiler trace for a Power BI dataset: Either the trace with the ID of ‘MicrosoftProfilerTrace1667261566’ does not exist …

A look at automatic partition maintenance by Power BI Service for datasets with Incremental Refresh

In this post, I am going to look at automatic partition maintenance by Power BI service for datasets with Incremental Refresh and focus on what happens to the partitions as time goes by. To do this, I am going to set up a couple of sample datasets with different Incremental Refresh (IR) policies with and … Continue reading A look at automatic partition maintenance by Power BI Service for datasets with Incremental Refresh

Power BI Table Storage Modes and Model Types

I still get a lot of questions from various Power BI developers about table storage modes and how table storage modes affect an entire model’s type. Here is a post to summarize all table storage modes / model types. The following table storage options apply when creating a Power BI model. Table Storage ModeData Stays … Continue reading Power BI Table Storage Modes and Model Types

Hybrid Tables (In Power BI) Q&A

Are Hybrid Tables tied to a developer license type? No. Incremental Refresh and Hybrid tables are tied to workspace (dataset) type. They are set up in Power BI Desktop. A developer must have Pro or Premium Per User (PPU) license to publish the report to the service. See the next two paragraphs for workspace (dataset) … Continue reading Hybrid Tables (In Power BI) Q&A