Forum Discussion
rkapukaya
Helper I
Helper IPowerBI Report Server shared dataset can not display data on browser
i am using powerbi report server. I want to create a datasource and use this datasource on my multiple powerbi reports. Normally, i can create one datasource (.pbix) on cloud version and when i publi...
v-deddai1-msft
Community Support
Community SupportHi rkapukaya ,
Is your m query similiar to :
let
Source = OData.Feed("https://sample.com/Reports/api/v2.0/datasets(DatasetID)/data",null, [MoreColumns=true]),
#"Expanded More Columns" = Table.ExpandRecordColumn(Source, "More Columns", {"ID", "TITLE", "PRIORITY", "IMPACT", "MODIFIED", "CREATED"},
in
#"Expanded More Columns"
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello, try to change source type to Web. PBIRS returns data in json format.