Hi,How can I see datasets on PowerBI for Desktop that I created on PowerBI online. Online i can see datasets with the tables and so, but when i login to the desktop version I can't see this datasets... ThanksCheers

v-sihou-msft Wow. So all the people who were asking for this feature before it existed are out of luck? I mean, the whole reason I was looking forward to this was because I already had a file published that I wanted to download. But you're saying you can only download reports that were published after they introduced this feature? That is the stupidest thing I have ever heard. Why on Earth would it be that way? Microsoft has all the files I've ever uploaded. Just let me download them. There's a download button that someone went to the extra trouble of disabling on all the files I actually want to download. What's the point in not letting me download some of them just because they're old? The file is right there. New files and old files are all in my workspace. There is absolutely nothing different about the old files, so I can only conclude that Microsoft must have decided that we shouldn't be allowed to download old files for some reason, and then done extra coding to make sure that we couldn't. I swear I lose more confidence in this program and its developers with every new release. It's like they're putting deliberate effort into making things useless. Like half the developer team works on making the new feature while the other half works on breaking it before release. Surely it would be easier to allow users to download any of their files than it is to restrict some of them. I love the DAX language and the Power BI workflow in general, but I am getting frustrated enough to start considering other software options at this point. Every month we get new features that are half-baked and missing the functionality that the users were actually asking for in the first place, and those problems are never fixed in future releases. Every month I get excited to read the feature list but a few minutes later I always discover that I can't use any of them. In the last year the one single new feature I've actually been able to use in a published report is the Shape Map. And none of my users really use or care about the map so it is literally just a decoration to make a few pages look nice. The program is absolutely littered with abandonned features that were half-implemented and never revisited. Conditional formatting, basic expected matrix functionality, trendlines, forecasting, drill-down to records, organizational content packs, printing, KPIs... I guess we can just add this to the growing pile of things that sound nice but don't actually work. What wonderful news to start out my week.

kmob Since you have already create a dataset on Power BI, you can create a report based on this dataset, then download a .pbix copy of this report. The dataset will be imported into the .pbix file. Regards,

kmob When login in Power BI Desktop, it's just for publishing the report onto Power BI service. We can't directly view the published content within Power BI Desktop since it's just a design tool. Regards,

Anonymous We already reported this issue to Product Team internally. Sorry for inconvenience. Regards, Simon Hou

kmob A data set in the Service is the data source, reports, metadata, etc contained in the PBIX. To confuse the issue, it could also just be a data source if you directly connect from the Service.Datasets are not a 1 to 1 match between the Service and the Desktop - this may help out a bit in explaining it further. Look under the "Understanding data refresh" section.

How to display datasets on PowerBI for Desktop?

15 Replies

Anonymous
Not applicable
9 years ago
kmob A data set in the Service is the data source, reports, metadata, etc contained in the PBIX. To confuse the issue, it could also just be a data source if you directly connect from the Service.
Datasets are not a 1 to 1 match between the Service and the Desktop - this may help out a bit in explaining it further. Look under the "Understanding data refresh" section.
- kmob
  Regular Visitor
  9 years ago
  Anonymous thanks for the response but I am not sure If I was clear...
  So we created this datasets with the powerBI API, so within our java program, we have one json and we created the dataset online folowing the api instructions (obtain token and post data).
  
  The problem is that we can see this dataset in PowerBI online but we cannot see this in powerBI for Desktop. Why? and how can we see this data?
  
  thanks
  - v-sihou-msft
    Microsoft Employee
    9 years ago
    kmob
    
    Since you have already create a dataset on Power BI, you can create a report based on this dataset, then download a .pbix copy of this report. The dataset will be imported into the .pbix file.
    
    Regards,
GilbertQ
Super User
9 years ago
Anonymous could an option not to be to connect with Excel to Power BI?

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-analyze-in-excel/

In doing that you could then see and pivot your dataset?

Forum Discussion

How to display datasets on PowerBI for Desktop?

15 Replies

Related content

Refresh dataset api

Power BI Desktop - No Power BI Datasets Connection

Power BI Desktop – Icon Display Issue

Cannot display Custom Visuals on desktop

Image display in Power bi report