Problem using Power BI Service as data source

[akensik]

I have problems using Power BI Service as data source.

I created a blank pbix-File with some sample data via Enter Data and published it to the service.

When I try to use this as data via Get Data>Power BI Service in a new pbis-File I get this error message:

Unexpected Error,

An error occured while loading the model for the item or data source xxx. Verify that the connection information is correct and that you have perissions to access the data source.

I have no idea how to fix this. When I try this in a complete new PowerBI free account it works.

Any idea which mistake I made?

Thank you

Andreas

[akensik]

In the meantime I tried it with a new user in my domain. Same error. Maybe something wrong with my domain?

But I don't know where to edit the permissions.

[Anonymous]

@akensik,

I test your code in Power BI Desktop, everything works well when I use Power BI Service as data source. Does the issue occur on this specific PBIX file?

Regards,
Lydia Zhang

[akensik]

@Anonymous,

no, it happens with every file.

Regards,

Andreas

[Anonymous]

@akensik,

I would recommend you create a support ticket in support.powerbi.com site.

Regards,
Lydia Zhang

[akensik]

@Anonymous,

OK. I'll try that. Thank you so far.

Regards,

Andreas

[Anonymous]

Hi @akensik,

I test the scenario as yours, but I am unable to reproduce your issue. Do you use the latest version of Power BI Desktop(2.46.4732.721)? Which workspace do you publish the PBIX file? Would you mind sharing me the PBIX file so that I can test?

Regards,
Lydia Zhang

[akensik]

Dear @Anonymous

Thank you for your assistance.

Yes my version is: Version: 2.46.4732.721 64-bit (Mai 2017)

I published it to My Workspace. How can I share it with you?

Regards,

Andreas

[Anonymous]

@akensik are you publishing the initial PBIX to a workspace in which you are not an admin? You need edit rights on the datasource in order to use it in a different PBIX.

[akensik]

Thank you for your reply @Anonymous. It' s a complete new PBIX file, contain only a single datasource with some manually entered values:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmDSBEyagkkzpdhYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Test = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Test", Int64.Type}})
in
    #"Changed Type"

I published it to My Workspace.