Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pkilo
Frequent Visitor

Calendar table looks ok in query editor, but do not refresh into reports

Calendar Table (excel import) changes the boolean rules

 

I have made the calendar table in a Excel and imported it into Power BI. It worked fine until now.

 

But know, the PowerBI turned all "ThisMonth", "LastWeek" ect. boolean rulevalues wrong. Why so??

 

In Excel, the column value still shows ok
= ThisMonth is May
PowerBI Query Editor table shows ok
= ThisMonth is May
But in PowerBI, after import, it shows wrong
= ThisMonth is April

 

And same for last week rule also - lastweek in Excel is ok, but the Last Week in Power BI
is week 15 (now it's 18).....

PowerBI basic time functions seems to understand the correct time. Today in 2017/05/05.


I made an extra column to calendar table and it looked ok in Query editor, but it did not refresh it into
reports. There the calendar table looks still the old one and mayby this is the reason, why all the boolean rooles are incorrect
also. The calendar table content is not refreshed, eventough I'm trying to refresh it and the "Include in Report refresh"is enabled.

Any help for this?

4 REPLIES 4
Eric_Zhang
Employee
Employee


@pkilo wrote:

Calendar Table (excel import) changes the boolean rules

 

I have made the calendar table in a Excel and imported it into Power BI. It worked fine until now.

 

But know, the PowerBI turned all "ThisMonth", "LastWeek" ect. boolean rulevalues wrong. Why so??

 

In Excel, the column value still shows ok
= ThisMonth is May
PowerBI Query Editor table shows ok
= ThisMonth is May
But in PowerBI, after import, it shows wrong
= ThisMonth is April

 

And same for last week rule also - lastweek in Excel is ok, but the Last Week in Power BI
is week 15 (now it's 18).....

PowerBI basic time functions seems to understand the correct time. Today in 2017/05/05.


I made an extra column to calendar table and it looked ok in Query editor, but it did not refresh it into
reports. There the calendar table looks still the old one and mayby this is the reason, why all the boolean rooles are incorrect
also. The calendar table content is not refreshed, eventough I'm trying to refresh it and the "Include in Report refresh"is enabled.

Any help for this?


Could you share the your pbix and excel files? You can upload them to a network drive and share a link.

Sorry, I'm not able to share the data = too much data blurring, since it's business confidential.

 

But it seems, that there are lot challenges with the data between the query editor and reports.

In query editor, the seems to look ok, bu in report builder it does not. Calendar data is not refreshed to reports.

All other querys are refreshed ok.

 

 

It worked, If I deleted the original Calendar Table and imported it again, but it's not an ideal solutions, since all my

reports use the calendar table and issue appears in every one of those.

 

And like I said - The reports worked earlier. I haven't done any changes.  Calendar stopped to work approx. month

ago.

prateekraina
Memorable Member
Memorable Member

Happnened with me once. Follow below steps, might work for you as well:

 

1. After opening Query Editor, Close & Apply changes.
2. Go to Data tab in Power BI.

3. Click on Refresh.

Answer 3.PNG

@prateekraina this is my normal rutine and this is not working currently.

I deleted the calendar table and imported it again and afterwards it worked fine, but this is not an ideal solutions to

do for every reports.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.