Forum Discussion
Cannot Retrieve Table from Power BI Model Published in Service using Import Mode
Hi Kaycee ,
There really isn't a 'Make changes to the model' option when your storage schema is Mixed.
If you want to get the table data from the service's semantic model in import mode, use the XMLA endpoint or workspace server URL. this is only available if you have Advanced or Embedded capacity.
- In the service workspace settings, copy the XMLA endpoint URL found under the Premium tab.
- Instead of using Get Data from Power BI Services (which automatically creates a live connection), use Get Data from Analysis Services.
- Paste the XMLA Endpoint URL copied from the service as the server address. You can select the connection you want to base the import on.
For more detailed steps and notes, refer to the link: How to IMPORT data from a Power BI dataset - Premium-only - RADACAD
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Kaycee ,
If you click on the the bottom rigth of the PBI you can access the import mode:
From the screen above you can change to import mode.
Thanks MFelix for taking the time to respond.
Unfortunately, the option to 'Make changes to the model' isn't there.
Also, I'm aware that in the past if I tried to go into the Query Editor when I had a direct query, it would prompt you to create a local model. That has also changed, it simply opened Query Editor with no prompt and because the table imported is in DirectQuery, it doesn't show in that place.
Any other roads to Rome?
