cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Grumelo Advocate II
Advocate II

SSAS 1400 - Web Data Source

First of all, I think a new Location should be created for SSAS 1400. "Report Server" is the wrong location for this post but I don't have a better one...

 

This new compatibility level of SSAS allows you to use on M Query language to define the Data Source of your Model.

 

In a way this is the alternative to the Content Packs on Power BI online.

You can develope your Tabular Data Model with Power BI desktop and then implement it on SSAS without having to recode your queries with SSIS.

 

My issue is that todays SSAS 1400 accept JSON File as a Data Source but only local files.

MS Excel or Txt files are accepted too but always as local file only.

 

How could it be I can not used the very basic Web Content connector ??!

1 ACCEPTED SOLUTION

Accepted Solutions
Willson_Yuan
Frequent Visitor

Re: SSAS 1400 - Web Data Source

@Grumelo

 

Thnaks for your question.

 

>>>My issue is that todays SSAS 1400 accept JSON File as a Data Source but only local files.

MS Excel or Txt files are accepted too but always as local file only.

How could it be I can not used the very basic Web Content connector ??!

For this issue, I agree with you.  We can only connect to local files currently.  I would recommend to submit it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback. 

View solution in original post

2 REPLIES 2
Willson_Yuan
Frequent Visitor

Re: SSAS 1400 - Web Data Source

@Grumelo

 

Thnaks for your question.

 

>>>My issue is that todays SSAS 1400 accept JSON File as a Data Source but only local files.

MS Excel or Txt files are accepted too but always as local file only.

How could it be I can not used the very basic Web Content connector ??!

For this issue, I agree with you.  We can only connect to local files currently.  I would recommend to submit it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback. 

View solution in original post

Grumelo Advocate II
Advocate II

Re: SSAS 1400 - Web Data Source

Thanks for the link.

I have posted by request on the SQL 2017 feedback form.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.