Forum Discussion
Helper IIthis table cannot be shown because it is not in import mode.
I did a "get data from powerbi semantic models"and after that ,if i click it in table view,it says: this table cannot be shown because it is not in import mode.
after success add,when i open the table view
Hi yanzhao_LBS
The datasource will dicatate wether you can connect to the data model as a direct query or load.
If direct query you cannot look inside the tables.
There is a way of jerry rigging it by using Create Table and then setting the new table equal to the old table. This will force the table to load and is known as a calculated table. You MUST remove calculated tables before pubishing as models connected to Semantic Direct Queries DO NOT support calculated tables.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand
Here is an article explaining import modes:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
4 Replies
- SamWiseOwl
Super User
Hi yanzhao_LBS
The datasource will dicatate wether you can connect to the data model as a direct query or load.
If direct query you cannot look inside the tables.
There is a way of jerry rigging it by using Create Table and then setting the new table equal to the old table. This will force the table to load and is known as a calculated table. You MUST remove calculated tables before pubishing as models connected to Semantic Direct Queries DO NOT support calculated tables.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand
Here is an article explaining import modes:
https://learn.microsoft.com/en-us/power-bi/connect-data/service-dataset-modes-understand
- shafiz_p
Hi yanzhao_LBS You see this becasue data set is not in import mode. It is a live connection. There is few work arounds with certain condition to bring data in import mode. Check out the earlier post:
Hope this helps!!
If this solved your problem, please accept it as a solution!!
Best Regards,
Shahariar Hafiz
Hi yanzhao_LBS ,
There are three connection modes in Power BI, Import/Direct Query and Live connection.
Import: Power BI loads all data into the data model.
Direct Query: Power BI will only load metadata such as column headings into the data model.
Live Connection: Power BI will connect to the Data Source via a live connection and will not load anything into the data model. You need to create the data model in the Data Source.
When the data source is a power bi semantic model, the default connection is live connection which can be seen in the bottom right corner. So you can't see the data in the table view.
You can click Make changes to this model to convert it to DirectQuery mode. You can also take a page from the method provided by shafiz_p to put the data in import mode.Here are some blogs and I hope they could help you.
For refernece:
DirectQuery in Power BI - Power BI | Microsoft Learn
What's the difference between live connections and DirectQuery? - Power BI | Microsoft Learn
Power BI Connection Types: DirectQuery, Live, or Import? Tough Decision!
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Has there been an update that will now allow this? I have a shared Semantic model and I created a new table off of it for my visuals, then published and don't see any issues. Question if the shared Semantic Model changes, will my table that pulls from it also update?
