How to connect to a semantic model and import the data

[AliPoTD]

Hello,

This may be straightforward to most but I'm fairly new to Power BI and am stuck on a query.

I have used Power BI desktop to create a Calendar data table which I have published to Powr BI Service.

My intention is to use this 1 calendar table for all reports so that, it can be updated once a year with specific changes to the FY required within my company.

I have now made a new report and have a Direct Query to the Calendar file. All working fine.

However, I now need to merge the Calendar table with another in Power Query but I can't see the table in the Powre Query list.

I understand why, due to it being a connection to live data.

However, what can I do to make the Calendar table one that can be imported rather than it being a live connection?

The Calendar table will only be updated once a year with the next year's information.

I just needed to have 1 data source so that a) only 1 report needs to be updated each year, and b) so that the company didn't have lots of variations of "Calendar" being used in various reports to ensure consistency.

How can I achieve this please? Do I need to do something other than a Seamntic flow? As mentioned, I'm fairly new and not sure what other options are available.

Many thanks! 

[AliPoTD]

Hi, thanks for responding.

1. I have created an excel spreadsheet called Calendar with several columns including Date, FY Year, FY Week etc.

2. I have imported the Excel spreadsheet into Power BI Desktop and called it Calendar.

3. I have published the Calendar.pbix to the company workspace so that others can link to the semantic model for their own reports.

4. I have created a new PB desktop report "A.pbix" and have linked to the Calendar semantic model previously published in step 3. It shows in the list of Tables but not in Power Query.

5. I would like to merge the Calendar information into another table at Power Query level.

Herein lies the issue. As the Calendar table is a Direct Query, it won't show in Power Query. How can I connect to the Calendar data that has been published to the Company Workspace as an Import - so that I am just taking a snapshot of the data - rather than connecting to it live through Direct Query?

[Anonymous]

Hi @AliPoTD ,

Base on your description,  it seems like you are trying to merge two calendar tables in Power Query. However, one of them can't be seen in Power Query. May I know is that calendar table which not display in Power Query is a calculated table? Calculated tables are created after the data has been loaded into the data model, so they are not visible in Power Query...

Solved: Include calculated columns in Power Query - Microsoft Fabric Community

---

No can do.  Calculated columns are calculated after the query loads.  You'll have to recreate your DAX column in the query editor with nested ifs (or make additional DAX columns, if it can be done that way for you new column(s)).

---

Solved: Created tables using DAx doesn't show in Power Que... - Microsoft Fabric Community

Best Regards