Report Template doesn't load the measure table when it is open

[wtreadway0129]

Hello all,

I'm trying to create my first report template in Power BI. We put our pbix files into GitHub however this one I'm trying to put into a tempate is 15gb big. I do not want to put that into GitHub so I'm making it in to a pbit file rather than a pbix. This is pretty simmple build: The main data (with incremental refresh) with all the data, two feild parameters tables and a table holding all my measures. Everything work, the dataset and report are deployed to the workspaces without issue.

However, when I try to reopen the templeate, after I put in the values for the IR parameters the "Refresh" window opens and tries to process the main table, the measure table and the query parameters for IR. 

I get the following message on the Measure Table "This query does not have any columns with the supported data types. It will be disabled from being loaded to the model. When I click continue the measure table is delted from the model entierly. Nothing I've found to do brings it back. I've tried to diable "detect data type", it doesn't help. 

Any idea what I'm doing wrong?

[rajendraongole1]

Hi @wtreadway0129 -Measure table does not rely on any columns that are expected to have data but do not. Measures themselves do not need columns, but if the measure table in your .pbix file had columns that were converted to measures or were not required in the .pbit, ensure that the data types are appropriately handled.

Create a new Power BI file with a simple measure table.
Add a basic measure to this table and see if it loads correctly in a new .pbit file.

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

Optimization guide for Power BI - Power BI | Microsoft Learn

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!