Connecting to Push Dataset via SSMS

[Anonymous]

Hi everyone,

I was following the post below to connect to the dataset in our organizational workspace.

https://docs.microsoft.com/en-us/power-bi/service-premium-connect-tools

I was able to establish a connection successfully, however, one thing I noticed was that the push dataset I created was missing. Is this by design or I actually missed something (like permission setting I guess) to connect to the push dataset in SSMS? The other datasets (created by uploading the pbix files to the workspace) works fine in the SSMS.

[Anonymous]

This might be due to Push datasets not using Premium capacity. From an earlier convo with MS Support, Push datasets, even on premium workspaces, use Shared Capacity. If this is still the case, the dataset won't show in SSMS.

[v-piga-msft]

Hi @Anonymous ,

I have a little confused about your scenario. It seems that you follow the steps in To connect in SSMS .

---

I was able to establish a connection successfully, however, one thing I noticed was that the push dataset I created was missing. Is this by design or I actually missed something (like permission setting I guess) to connect to the push dataset in SSMS? The other datasets (created by uploading the pbix files to the workspace) works fine in the SSMS.

---

What push dataset do you mean? In addition, do you mean that you could connect the other dataset in the premium workspace successfully in the SSMS except for the push dataset?

If it is convenient, could you share more details with screenshots or any error message? Please do mask sensitive data before uploading.

Best  Regards,

Cherry

[Anonymous]

Hi @v-piga-msft ,

The push dataset I mentioned refers to the one created with Power BI REST API ( I followed this tutorial: https://docs.microsoft.com/en-us/power-bi/developer/walkthrough-push-data)

Once it's done, these datasets are available to me under the "Datasets" tab in the workspace and I was able to create a report using them directly in Power BI.

However, in the SSMS in the Object Explorer, they are just missing ... I didn't see any error messages and everything else worked smoothly ... So I guess the push datasets are handled in a way different from the other datasets in the analysis server?