Getting started some basic questions

[Anonymous]

Hi Experts.

I have some basic questions can I get help please

1. Working on SSMS,  I can only select do not have create access and created a report with window functions 

how can I connect this to power BI ? (no table create access)

2. If I have all the data I need, Do I still need to create Dim tables and fact tables in power query for effective filtering, my understanding says Yes, but I need your input ( I expand on this, I have dates in FY, Quarters, departments, sales, etc) I need to filter on various data ( Can I understand, what answer you give here also valid of date being created) 

3. How do I get to maximize the viewing page so I can create click on name button menu (Example. Department filter witl list of names for me to click ? ) 

4. How can I have entire page back ground in different color with my company logo ? 

[Anonymous]

Please ignore the 3rd one and yes i got the 4th one to responsive. Thank you @lbendlin  much appreciated.

I am able to connect to tables via SMMS at my home computer via source as SQL Data, How can I use XMLA queries you have given me,  do i need to replace the attributes in quotes with ?

[lbendlin]

You connect to SSAS source, not SQL source.  Power BI is similar to SSAS Tabular. Same rules for table creation etc 

[lbendlin · Accepted solution]

1.  You can create tables with XMLA queries. Look at the script for existing tables.  Something like

{
  "createOrReplace": {
    "object": {
      "database": "db",
      "table": "Dates",
      "partition": "Dates"
    },
    "partition": {
      "name": "Dates",
      "mode": "import",
      "source": {
        "type": "m",
        "expression": [
          "let",
          "    Source = Sql.Database(\"server\", \"db\"),",
          "    dbo_Dates = Source{[Schema=\"dbo\",Item=\"Dates\"]}[Data],",
          "    #\"Filtered Rows\" = Table.SelectRows(dbo_Dates, each ([Fiscal Year] = \"FY18\" or [Fiscal Year] = \"FY19\" or [Fiscal Year] = \"FY20\" or [Fiscal Year] = \"FY21\" or [Fiscal Year] = \"FY22\"))",
          "in",
          "    #\"Filtered Rows\""
        ]
      }
    }
  }
}

2. A well designed data model is worth a lot.

3. Not clear. Pleas elaborate

4. Go to the page properties. Have an appropriate image ready.  Read about themes.