Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Importing Data size

Hello everybody😊 I am new to Power BI I have just started my first Power BI project.   My problem is: 1.  I imported data from Dynamics 365 Database. But data size is 1.1GB after cleansing all ...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

    P1:
    Data Model Limitations in Power BI Desktop  

    dataset limitations  

    (Dataset is a concept in Power BI Service)

     

    P2:

    You can show the data by weekly.
    Here’s my original data.

    I created two columns and show values by weekly.

     

    Year = YEAR([Date])
Week = WEEKNUM([Date])

     

    Note: WEEKNUM() function Returns the week number for the given date and year according to the return_type value. The week number indicates where the week falls numerically within a year.

     

     

    Best regards,
    Lionel Chen

     

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

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

P1:
Data Model Limitations in Power BI Desktop  

dataset limitations  

(Dataset is a concept in Power BI Service)

 

P2:

You can show the data by weekly.
Here’s my original data.

I created two columns and show values by weekly.

 

Year = YEAR([Date])
Week = WEEKNUM([Date])

 

Note: WEEKNUM() function Returns the week number for the given date and year according to the return_type value. The week number indicates where the week falls numerically within a year.

 

 

Best regards,
Lionel Chen

 

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