cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Data not coming through in PowerBI report from PowerBI desktop

Hi there,

 

I am experiencing a strange issue when connecting a powerBI dataset to build a report.

 

I can see data for all the tables starting from year-2013 to 2021 in the powerBI dataset but when i connect it to build a report, it is only showing data starting from 2018.

There are no parameters set in the desktop or online service.

can 

 

 

1 ACCEPTED SOLUTION

Hi @StefanoGrimaldi 

I am using PowerBi desktop to create a report.

I can see the data (from 2013 to 2021) in the main dataset -"datasetonly" which i am using to connect & create report in PowerBi desktop.

chavanr_1-1611098512353.png

 

chavanr_0-1611098401898.png

 

After connecting to this "datasetonly" i can see data 2018 onwards.

View solution in original post

12 REPLIES 12
Community Support
Community Support

Hi @chavanr ,

Please try to select "Reset to default" in the upper right corner of the page and check whether you can see the "complete" data from Power BI Desktop:

revert to the default settings

reset to default.JPG

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @yingyinr Already done that 🙂

Hi @chavanr ,

Thanks for your reply. So it is working or not now? Can you see the full data same with the one in Power BI Desktop?

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @yingyinr nope, still cant see the data.

The issue is when i connect to a powerbi dataset to create report, 2017 data is not visible.

& there are no page level, report level filters or any parameters.

 

Cheers,

Rutika

Hi @chavanr ,

Which data source is your dataset connected to? Excel, SQL or other data sources? Can you confirm whether the underlying data source still contains the data from 2017?

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @yingyinr 

The issue is resolved now, found the filter in one of the table, which was quite hard to spot.

 

Many thanks,

Solution Sage
Solution Sage

strange, you try making a new report on the online service using the dataset instead of the power bi desktop, also check your table relantionship that could cause some data not be visible but maybe not that case cause of you describing it happening, can you share some pics of your data sets informations , settings etc when you use the like conection to bi dataset, vs how they seem on the main pbix of that dataset. to see if can see something there. 

Hi @StefanoGrimaldi 

I am using PowerBi desktop to create a report.

I can see the data (from 2013 to 2021) in the main dataset -"datasetonly" which i am using to connect & create report in PowerBi desktop.

chavanr_1-1611098512353.png

 

chavanr_0-1611098401898.png

 

After connecting to this "datasetonly" i can see data 2018 onwards.

View solution in original post

Super User IV
Super User IV

@chavanr , Is it power bi Published dataset? or normal data imported to power bi.

Unless there is page level filter or report level filter , you should able to see data visible in table.

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @amitchandak  Thanks for your response!

Sorry for the late reply.

Yes, it is a PowerBI published dataset.

I did check the page level & report level filters, there are none.

That's the reason I am bit surprised as to why it is filtering the data for last 4 years.

 

Unfortunately I cannot share the pbix file with you.

Solution Sage
Solution Sage

on the online service you can see all years? check create a report on the power bi service online and see if the same error occurs. if so you should check your power bi pbix file something will be filtering the dataset. 

Hi @StefanoGrimaldi thanks for your response !

Sorry for the late response !

Yes, I can see all the years in the dataset created when published to online service.

the issue happens when i connect that dataset to create report, there are no filters or parameters in the dataset.

 

Many thanks.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors