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.

1. In the service workspace settings, copy the XMLA endpoint URL found under the Premium tab.
2. Instead of using Get Data from Power BI Services (which automatically creates a live connection), use Get Data from Analysis Services.
3. 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.