Adding PowerBI dataset to my gateway: "invalid connection string"?

[bigchippah]

Do I actually have to add my data sources to the Gateway twice?  First as a "thin" file with data-only, and second as a PowerBI dataset?  If so, I'm really struggling with that second part:

1. I have my dataset in Desktop.  No visuals, just the data.  Published this to the Service and added all of my data sources to my Gateway.  So far, so good.

2. Created a new file in Desktop and connected to my PowerBI dataset.  Built some visuals and published this new file to the Service.  Now it's asking me to add my Power BI dataset to the cloud (as Analysis Services) and I keep getting an error:

Unable to create data source. An invalid connection string has at least one of the passed arguments which does not meet the parameter specification. Please check the data source connection string.

Authentication failed: User ID and Password are required when user interface is not available.

When adding the Power Bi datase to the gateway, Authentication Method is Windows and uses my work login.  Privacy level is "Private."  I don't have anything input in the "Map user names" section (EffectiveUserName is selected).

I went into my "Golden Dataset", looked at my source, and permissions seem fine.  What am I missing?

[edhans]

Did you add just one dataset to the new PBIX, or is it a composite model using DQ for AAS/PBI Datasets with other data? If the latter, is this a Pro or Premium workspace? If Pro, you must enable build permissions on the dataset. That restriction was removed from Premium a few months ago and will be removed from Pro, but it hasn't been done yet.

If it is just a single dataset, and there is NOTHING in the Power Query view (100% empty) then none of this should be necessary. When you write a report on another dataset, there is nothing to do once published. No refreshes, no nothing. It just looks at that dataset when a user refreshes a report.

[bigchippah]

Hi @edhans!  Thanks for the reply.

This is a composite model: there is my DirectQuery PowerBI dataset, as well as several Excel files in OneDrive.  It's a Pro workspace.

I'm the administrator for all of my datasets.  Do I still need to enable build permissions if I've built all of this stuff from scratch?  And if so, how do I go about doing that?  I've looked at the dataset, as well as the report and I am listed under "People and groups with access" with "Admin(Owner)" Permissions.

[edhans]

See this article on build permissions. The fact that you need it today in a Pro environment isn't the intended effect, but the composite model feature is still in preview, so it isn't done. That is why it is necessary.

Build permission for shared datasets - Power BI | Microsoft Docs

[bigchippah]

I tried to use this exact page before and couldn't figure it out. 

On second look (and managing to find my way to a page that actually says "Read,Build" Permissions), I see myself as Admin/Owner.  Shouldn't the below criteria apply to me?

Members of a workspace with at least a Contributor role automatically have Build permission for datasets in that workspace, and permission to copy a report.

[edhans]

You are going to have to provide some screenshots of exactly what you are doing every step of the way. I am not sure we are 100% using the same terminology. For example "Do I actually have to add my data sources to the Gateway twice?  First as a "thin" file with data-only, and second as a PowerBI dataset?" actually makes no sense in Power BI. You cannot add it as a thin file. Period.

I just spent 15min discussing with someone why they were getting a requirement to add their connection to a dataset to a gateway when it shouldn't be necessary. Turns out once they shared screens, they were connecting to a dataset in a SAP HANA database, which is not a Power BI dataset, and the converstation took a very different turn and became productive.