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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jmeijinhos
Regular Visitor

Problem getting data from SQL Server

Hey there,

I've been having some problems getting data from an SQL server.

 

Making a connection through PowerPivot (same relations, same tables, everything identical) works.

Making a connection thgough PowerBI doensn't work.

 

I'm able to get the tables, and almost all data through PowerBI, but the last months of sales don't show up.

I'm able to get data in PowerPivot until June (6) but only shows up until April (4) in PowerBI.

 

Is there any reason for this behaviour?

Also tried direct query vs import, no help.

2 REPLIES 2
v-cherch-msft
Employee
Employee

Hi @jmeijinhos

 

You may check the data between Query Editor and Data View. The data may change after making some queries ->apply some steps in Query Editor.

 

Regards,

Cherie

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

Anti-theft door repairs and fittings are one of the things that can not be carried out without adequate technical knowledge and tools, or to a satisfactory result. For this, we will give a brief explanation of this. v تعمیر و رگلاژ درب ضد سرقتOne of the most important and most important repairer's tools in this field is the welding machine used to move the hinges, and in some cases also used to boost sections of the anti-theft door that is fractured or defective. The most commonly used tool is a hammer and rod bar in the 50 cm dimensions used to lift the door or to create a shock in the parts of the anti-shock door that has been damaged and play a role of leverage and auxiliary impact. تعمیر و رگلاژ پنجره دوجداره Double-glazed windows require three main parameters, the most important of which is knowing the parts, that is, the double-pane window repairer must know what the function of each piece is and in the next step it must understand the relationship between the parts, for example, the relationship between Zamac and the Hub and Espanyolt Completely recognizable, and in the final stage, it can adjust all parts and parts in such a way that the door and pen function

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.