Power BI OnPremise - Reports didn't load correctly

[KBO]

Hallo,

I have a little problem with the Power BI Report Server. First I build a Cube in Visual Studio for a live conection, this works fine but If i go to the Power BI Report Server Client and will creat my Reports he show me this:

"This can not visualized" the Report failed an I can't see anything. But this only happend If I choose columns with the KeyColumn: WChar If I choose Columns with KeyColumn: Integer it all works fine. 

So my question to you: Know anyone this type of problem and have a simple solution, maybe a diffecult solution is also fine :). Can it be that this a problem comes from Power BI Client directly or can I solved the problem in Visual Studio?

I hope you can understand what's my problem ;).

Update: Now I can see the KeyColumn: WChar but only If I pick a other Report. See on the following pics:

Here you can see - If I click on the Report I marked the other Report showed something.

But If I havn't click on any Report you can see nothing in the other Report and a ErrorMessage is shown.

Thx for your answers.

[v-yulgu-msft]

Hi @KBO,

Did this report load data correctly in Power BI desktop before publishing to report server? What is the relationship between Donut chart 'Service Request' and table visual? Please check the measures you created for those visuals.

Please expand the error message for more detailed information.

Best regards,
Yuliana Gu

[KBO]

Hello @v-yulgu-msft and thank you for your answer but the mesures createt by itself. I need a SQL Cube for a live connection and so I must work on the table in Visual Studio but I don't know so much about this tool so it can be that I forgott somthing to do in this? The result which is show in Power BI Report Client is only a reflection from the Visual Studio. And If I load the data in Power Bi the mesures are still there without doing anything. I hope you can understand my problem now a little bit better?

Maybe the problem located here in Visual Studio:

I try some other attributes but until now nothing works....

Greetz Kathrin

[v-yulgu-msft]

Hi @KBO,

So, in your scenario, you didn't create any measure in Power BI desktop side, and you only create some visuals based on those data and measures created in SSAS cube, right? If you have any concern about create SSAS cube, personally, you'd better post your questions on SSAS forum so that you can get more professional advice. Besides, in Power BI desktop, we can also create measures to return desired values, if you have any concern, please illustrate your requirement with sample data.

Regards,
Yuliana Gu